Page 1 of 1

data manipulation

Posted: Tue May 06, 2008 9:38 pm
by kotikoti
Hi All,
Hope the title fits my query.
I am reading the data from a text file and this returns data similar to

Code: Select all

USB Mass Storage Device	USB\VID_054C&PID_0243\2A07110306315
USB Mass Storage Device	USB\VID_054C&PID_0243\2A07110306715
I need to use the last item (delimeter being "\") to process the next segment of code for each line encountered in a repeat for loop.

Query:
1). How do I capture this last item
2). My other files to use in subsequent processing is tab delimited, I believe the solution to one should point me to this one's else if different, please advice

Thanks.

Re: data manipulation

Posted: Wed May 07, 2008 12:43 am
by keyless
kotikoti wrote:Hi All,
Hope the title fits my query.
I am reading the data from a text file and this returns data similar to

Code: Select all

USB Mass Storage Device	USB\VID_054C&PID_0243\2A07110306315
USB Mass Storage Device	USB\VID_054C&PID_0243\2A07110306715
I need to use the last item (delimeter being "") to process the next segment of code for each line encountered in a repeat for loop.

Query:
1). How do I capture this last item
2). My other files to use in subsequent processing is tab delimited, I believe the solution to one should point me to this one's else if different, please advice

Thanks.
You are going to want to put the data from txt into a variable. then you are going to want to:
set item delimitor to ""
Repeat for each line lVariableName of lWhereDataIs
put item -1 & cr after lAnotherVariableName