data manipulation

[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.

[keyless]

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