AnsweredAssumed Answered

vrf Help me with CSV file (Demon)

Question asked by VRFuser on Oct 12, 2004

Like • Show 0 Likes0
Comment • 8

> String.Split from the new VEE 7 System menu will split a string
> and not ignore consecutive delimiters.

Awesome. So they're calling it split now? Ok... yup. That's nearly identical
to strtok. The major difference is split can take delimiters of more than
one character & there's post allocation & processing to return an array.
Good to know. Thanks for the example
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

No one else has this question

Outcomes

8 Replies

cjimenez Oct 11, 2004 3:24 AM
Mark Correct
Correct Answer
Hi to all.

The last week I send a question about a problem between the RPC Server
and ExcelApplication ActiveX Object, and somebody responded to me but
the problem did not finish being solved (the rpc server was not invoked
of remote way but of local way).

In any case besides to solve that problem which worries to me it is
that, when the Application object occurs begins to NULL and I do not
know what is the way of which with VEE it says to me if a ActiveX is
null or not.

I have already proven with "isVariantNull(ExcelApp)" but always it
returns 0 to me even when the problem occurs.

Somebody can help me?

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Oct 11, 2004 7:06 AM
Mark Correct
Correct Answer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content=text/html;charset=ISO-8859-1><META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD><BODY text=#000000 bgColor=#ffffff><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004>Yep, VEE is kind of dumb that way. You have to read in each line as a string, then use a separate routine to parse it. Several folks have posted pre-made parsing routines to the VRF in the past. Perhaps the archives could turn up one you can use.</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004></SPAN></FONT> </DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004>Along that line, I don't like the way VEE strips off "white space" from the front of any string you read in either. Really sucks when you have data carefully formatted the way you want, only to see it screwed up when read in. Skips over blank lines too. Instead of just inserting a CR/LF when it sees one, you get nothing. I'm not sure why it can't work more like Notepad. WYSIWYG.</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004></SPAN></FONT> </DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004>These are gripes of mine that I thought I would throw out one more time. In all fairness, I noticed a LOT of items in my old "gripe list" were addressed in VEE 7. To that I give my thanks. I would think that reading CSV files "correctly" could be a pretty easy fix (or toggle, like Excel) to throw in VEE Future.</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004></SPAN></FONT> </DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004>Cheers,</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=671583803-12102004>Mike</SPAN></FONT></DIV><BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Carlos Jimnez [mailto:cjimenez@ivic.ve]<BR><B>Sent:</B> Monday, October 11, 2004 4:25 PM<BR><B>To:</B> VRF<BR><B>Subject:</B> [vrf] Help me with CSV file (Demon)<BR><BR></FONT></DIV>Hi, Vrf Group<BR><BR>I have proble to try read CSV file (Events_4_10_2004.csv), from EXCEL I can read, but from VEE I can't. I solved the problem filling space between the commas with zero, but this I do opening first it the file with EXCEL.<BR><BR>Best Rgard,<BR><BR>Carlos Jimnez<BR> <DIV class=moz-signature><FONT face=Arial color=#0000ff size=2></FONT> </DIV></BLOCKQUOTE>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>
Like • Show 0 Likes0
Actions
detlef.baranski Oct 12, 2004 12:51 AM
Mark Correct
Correct Answer
There are some info and some examples available, maybe it helps:
http://www.preciselyso.co.uk/site_index.shtml

Have a look for clCSVfile and clVOL.

These samples were also part of an Agilent VEE Days - example-distribution
package under User Resource site...
dont know the actual Agilent link now, sorry....

Otherwise you can read and write via Excel directly, and there are some
functions in .net of course

best regards,
detlef

-----Ursprngliche Nachricht-----
Von: Mike Groves [mailto:mike@grovesnet.org]
Gesendet: Dienstag, 12. Oktober 2004 06:07
An: VRF
Betreff: [vrf] RE: Help me with CSV file (Demon)

Yep, VEE is kind of dumb that way. You have to read in each line as a
string, then use a separate routine to parse it. Several folks have posted
pre-made parsing routines to the VRF in the past. Perhaps the archives could
turn up one you can use.

Along that line, I don't like the way VEE strips off "white space" from the
front of any string you read in either. Really sucks when you have data
carefully formatted the way you want, only to see it screwed up when read
in. Skips over blank lines too. Instead of just inserting a CR/LF when it
sees one, you get nothing. I'm not sure why it can't work more like Notepad.
WYSIWYG.

These are gripes of mine that I thought I would throw out one more time. In
all fairness, I noticed a LOT of items in my old "gripe list" were addressed
in VEE 7. To that I give my thanks. I would think that reading CSV files
"correctly" could be a pretty easy fix (or toggle, like Excel) to throw in
VEE Future.

Cheers,
Mike
-----Original Message-----
From: Carlos Jimnez [mailto:cjimenez@ivic.ve]
Sent: Monday, October 11, 2004 4:25 PM
To: VRF
Subject: [vrf] Help me with CSV file (Demon)

Hi, Vrf Group

I have proble to try read CSV file (Events_4_10_2004.csv), from EXCEL I can
read, but from VEE I can't. I solved the problem filling space between the
commas with zero, but this I do opening first it the file with EXCEL.

Best Rgard,

Carlos Jimnez
This message and any attachments are confidential, for the exclusive use of
the addressee and may be legally privileged. Any other distribution, use or
reproduction is unauthorised and prohibited. If you have received this
message in error, please notify the sender immediately and delete the
message from your system.

Visit our internet site at http://www.pilkington.com

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
detlef.baranski Oct 12, 2004 1:36 AM
Mark Correct
Correct Answer
There is a White Paper available which describes how to use .net functions
to read and write to CSV files. Should also work via Vee7:
http://adn.tm.agilent.com/index.cgi?CONTENT_ID=1352 at the bottom.

Title: Storing Test Data to File Using Microsoft Visual Basic .NET Code
Samples

-----Ursprngliche Nachricht-----
Von: Baranski, Detlef
Gesendet: Dienstag, 12. Oktober 2004 15:51
An: VRF
Betreff: [vrf] RE: Help me with CSV file (Demon)

There are some info and some examples available, maybe it helps:
http://www.preciselyso.co.uk/site_index.shtml

Have a look for clCSVfile and clVOL.

These samples were also part of an Agilent VEE Days - example-distribution
package under User Resource site...
dont know the actual Agilent link now, sorry....

Otherwise you can read and write via Excel directly, and there are some
functions in .net of course

best regards,
detlef

This message and any attachments are confidential, for the exclusive use of
the addressee and may be legally privileged. Any other distribution, use or
reproduction is unauthorised and prohibited. If you have received this
message in error, please notify the sender immediately and delete the
message from your system.

Visit our internet site at http://www.pilkington.com

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Oct 12, 2004 9:46 AM
Mark Correct
Correct Answer
<HTML><HEAD><TITLE>Let Hunter's Friend treat you to a great vacation</TITLE><BODY><TABLE cellSpacing=1 cellPadding=2 width="94%"><TR bgColor=#0fca10><TD colSpan=3 height=36> <P > <BR> <TABLE cellSpacing=1 cellPadding=1 width="75%" border=1 align=center> <TR> <TD> <P align=center><IMG alt="" hspace=0 src="http://www.huntersfriendresort.com/images/new%20logo.gif" align=baseline border=0></P></TD> <TD> <P align=center><FONT color=#ffff00 size =5 ><IMG alt="" hspace=0 src="http://www.huntersfriendresort.com/egram/turkey.jpg" align=baseline border=0></FONT></P></TD></TR></TABLE></P><STRONG><FONT face="Arial, Helvetica, sans-serif" color=#0fca10 size=5> <P align=left></STRONG></FONT> </P></TD></TR><TR bgColor=#0fca10><TD width="3%" bgColor=#0fca10> </TD><TD vAlign=top align=left bgColor=#000066 colSpan=2><FONT face="Georgia, Times New Roman, Times, serif" color=#ffffff size=3> <H1 align=center><FONT face="Times New Roman" color=#ffff00 size=5 style="BACKGROUND-COLOR: #000066"> We would like to invite you to our Thanksgiving party!!!</FONT></H1></FONT><TABLE cellSpacing=0 cellPadding=4 width="99%"><TR><TD vAlign=top align=left width="36%" bgColor=#cccccc height=139><P><STRONG><FONT face="Arial, Helvetica, sans-serif" color=#000000 size=2>Menu:</FONT></STRONG></P> <UL><LI><FONT face="Arial, Helvetica, sans-serif" size=2> Succulent turkeys baked to perfection</FONT> <LI><FONT face="Arial, Helvetica, sans-serif" size=2> Honey glazed hams</FONT> <LI><FONT face="Arial, Helvetica, sans-serif" size=2>Delectable mashed potatoes and turkey gravy</FONT> <LI><FONT face=Arial size=2>Mushroom and celery stuffing</FONT> <LI><FONT face=Arial size=2>Green bean casseroles</FONT> <LI><FONT face=Arial size=2>A variety of salads</FONT> <LI><FONT face=Arial size=2>Iced Tea</FONT> <LI><FONT face=Arial size=2>Pumpkin and apple pies</FONT> <LI><FONT face=Arial size=2>and much more</FONT></LI></UL> <P align=center><FONT face=Arial size=2><IMG alt="" hspace=0 src="http://www.huntersfriendresort.com/images/turkey.gif" align=baseline border=0></FONT></P> <P><FONT face=Arial size=2>All this for the incredibly low price of $5.00 per person!!!</FONT></P> <P><FONT face=Arial size=2>No kidding. </FONT></P></TD><TD vAlign=top align=left width="64%" bgColor=#ffffff><P><STRONG><FONT face="Arial, Helvetica, sans-serif" color=#000000 size=2>Hunter's Friend would like to invite you and your family to our resort for a special gathering on Thanksgiving day. This is an exclusive offer only for our guests and their families and will be limited on a first come, first serve basis in our new convention center. Last Thanksgiving was the busiest time of the year for us outside of the 4th of July and we anticipate it will be the same this year. </FONT></STRONG></P><STRONG><FONT face="Arial, Helvetica, sans-serif" color=#000000 size=2><P><IMG alt="" hspace=0 src="http://www.huntersfriendresort.com/building/dinner.jpg" align=baseline border=0></P> <P><FONT face=Arial size=2>A four night minimum <STRONG>will be required</STRONG> during the week of the 22nd through the 28th of November, 2004. Any guest as well as their family and friends who stay at our resort and meet the minimum night requirements will be eligible for our Thanksgiving feast. You must make your reservations by the 31st of October, 2004. You can check online availability by clicking <A href="http://www.webervations.com/magic-scripts/resbook.asp?memberid=Izmir">here </A>or by simply calling us at 800 338 2842. </P><P> </FONT> </P></FONT></STRONG></TD></TR><TR bgColor=#000066><TD vAlign=top align=left colSpan=2 height=52><DIV align=center><FONT style="BACKGROUND-COLOR: #000066" color=#ffff00 size=5>Come and celebrate the wonderful year we all have enjoyed.</FONT></DIV></TD></TR><TR><TD vAlign=top align=left bgColor=#cccccc> <DIV align=left><STRONG><EM><FONT face=Georgia color=#003366><DIV align=left><FONT face="Georgia, Times New Roman, Times, serif" color=#003366><STRONG><EM>Hunter's Friend has been serving the public in Branson for more than 32 years. We succeed because we care about your satisfaction and offer free amenities that other resorts typically charge their guests for.</EM></STRONG></FONT></DIV></FONT></EM></STRONG></DIV><DIV align=left><STRONG><EM><FONT face=Georgia color=#003366></FONT></EM></STRONG> </DIV><DIV align=left><STRONG><EM><FONT face=Georgia color=#003366></FONT></EM></STRONG></DIV><DIV align=left><STRONG><EM><FONT face=Georgia color=#003366></FONT></EM></STRONG> </DIV><DIV align=left><STRONG><EM><FONT face=Georgia color=#003366><P><FONT face="Georgia, Times New Roman, Times, serif" color=#003366><STRONG><EM>Removal Instructions</EM></STRONG></FONT></P><P><FONT face="Arial, Helvetica, sans-serif" size=2> We apologize if you received this email in error. To prevent future mailings please do the following:<BR>Send a blank email from the address receiving this email to <A href="mailto:mike@huntersfriendresort.com">mailto:mike@huntersfriendresort.com</A> with the word REMOVE in the subject.</FONT></P></FONT></EM></STRONG></DIV><DIV align=left><STRONG><EM><FONT face=Georgia color=#003366><A href="http://www.peakperformancellc.com/register3.htm"></A></FONT></EM></STRONG></DIV> <DIV align=left><STRONG><FONT face=Georgia color=#003366><EM></EM> </FONT></STRONG></DIV> <DIV align=left><STRONG><FONT face=Georgia color=#003366></FONT></STRONG> </DIV> <DIV align=left><STRONG><FONT face=Georgia color=#003366></FONT></STRONG> </DIV> <DIV align=left><STRONG><FONT face=Georgia color=#003366></FONT></STRONG> </DIV> <DIV align=left><STRONG><FONT face=Georgia color=#003366></FONT></STRONG> </DIV> <DIV align=left> </DIV> <P><STRONG><FONT color=#660066> </FONT></STRONG> </P></TD><TD vAlign=top bgColor=#ffffff><TABLE cellSpacing=4 cellPadding=2 width="99%"></TABLE><TABLE cellSpacing=2 cellPadding=1 width="97%" border=0><TR><TD vAlign=top><P><FONT face="Arial, Helvetica, sans-serif" ><FONT face=Georgia><EM><STRONG>Our location is ideal for those guests who want to wrap up any last minute Christmas shopping or catch a show or two. Close enough to the action, without all the grief from Branson's traffic.</STRONG></EM></FONT> </FONT></P><P><FONT face="Arial, Helvetica, sans-serif" size=2> <A href="mailto:mike"></A> </FONT> </P></TD></TR></TABLE> <P align=center><IMG alt="" hspace=0 src="http://www.huntersfriendresort.com/images/bransonoverallmap.gif" align=baseline border=0></P></TD></TR></TABLE><P> </P></TD></TR><TR><TD colSpan=2> </TD><TD width="45%"> </TD></TR><TR><TD colSpan=2> </TD><TD> </TD></TR><TR><TD colSpan=2> </TD><TD> </TD></TR></TABLE>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>
Like • Show 0 Likes0
Actions
VRFuser Oct 12, 2004 8:45 PM
Mark Correct
Correct Answer
I agree that VEE insists on there being the same number of commas in every
line. But I disagree about empty fields not being a problem. Shawn's example
uses spaces as fake data so that no field is empty. Deleting the spaces so
that there are consecutive comma's (a truly empty field, but consistent
number of commas per row to start with) will generate an error.

The real problem is that VEE insists on treating "multiple delimiters as
one". This is the same reason that blank lines are skipped when reading
lines of text into an array.

Life would be a lot easier if VEE, like Excel, made the treatment of
consecutive delimiters configurable. It's amazing that software primarily
meant for data gathering cannot properly read and write CSV files.

Best Regards,

Vic Race
Lindsay Electronics

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Oct 12, 2004 9:50 PM
Mark Correct
Correct Answer
> Shawn's example uses spaces as fake data so that no field is empty.

Well! It's an easy solution

> Deleting the spaces so that there are consecutive comma's
> (a truly empty field, but consistent number of commas per
> row to start with) will generate an error.

Quite true. It's only a band-aid cure.

> The real problem is that VEE insists on treating
> "multiple delimiters as one".

It *is* odd that it's not handled differently. It was probably a design
decision way, way back. VEE didn't have the ability to return a true null
value until it adopted Variant, so the only choice would have been to return
an empty string. asInt("") returns an error, so conversion of null strings
is now the problem. I can see somebody saying, "just skip it".

> Life would be a lot easier if VEE, like Excel, made the
> treatment of consecutive delimiters configurable.

An excellent suggestion for an upgrade - or a bug fix if you like.

In the mean time, the CRT function strtok can be used to achieve basically
the same effect - though of course with a lot more effort. Kernel32.
FormatMessage can also be used to do token replacement in strings. Read the
original csv in as a 1D array with a regular From File, then before feeding
an individual line to From String to tokenize, use FormatMessage to replace
instances of commas with comma space.

It does manual data normalization without the hassle of making sure the
generator application is designed correctly.
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
corey.wills Oct 12, 2004 10:48 PM
Mark Correct
Correct Answer
> String.Split from the new VEE 7 System menu will split a string
> and not ignore consecutive delimiters.

Awesome. So they're calling it split now? Ok... yup. That's nearly identical
to strtok. The major difference is split can take delimiters of more than
one character & there's post allocation & processing to return an array.
Good to know. Thanks for the example
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions

vrf Help me with CSV file (Demon)

Outcomes

Related Content

Recommended Content