macsilber 0 Posted December 22, 2011 Report Share Posted December 22, 2011 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. Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted December 22, 2011 Report Share Posted December 22, 2011 you can do 2 things. add the data to a csv (very easy)save to a file, create table from filecall 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.. Quote Link to post Share on other sites
Praney Behl 314 Posted December 23, 2011 Report Share Posted December 23, 2011 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 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.