Parse for second element of a comma delimted list

[macsilber 0]

As an example I have a line of text

 

61024221,ballanty,2,0,$102,,34,12/22/2011 09:08,Reliable

 

I want to extract the 2nd element ballanty and the firth element $102.

 

Can someone guide me perhaps.

[LoWrIdErTJ - BotGuru 904]

you can do 2 things.

 

add the data to a csv (very easy)

save to a file, create table from file

call the needed info

 

 

create a list, list from text, delimter ,

call the second line (1)

 

 

I dont feel regex is going to be the way to go as you would have to set anchors for left and right side, and it repeats later in your line. would return bad data.

 

I think the above is your best bet..

[Praney Behl 314]

You can also scrape the data and add to list using list from text. Now you can pick the required list item using exact list position ...

 

Easy peezy!

 

Hope it helps.

 

Praney