Hope this helps a bit: set s to "a|b|c|d|e|row1col6|row1col7|rest z|y|x|w|v|row2col6|row2col7|rest" join (find text "^([^|]+\\|){5}([^|]+)\\|([^|]+)\\|" using "\\2" in (get paragraphs of s) with regexp and string result) using "|" -- row1col6|row2col6 join (find text "^([^|]+\\|){5}([^|]+)\\|([^|]+)\\|" using "\\3" in (get paragraphs of s) with regexp and string result) using "|" -- row1col7|row2col7 Emmanuel On Nov 3, 2009, at 11:22 PM, [log in to unmask] wrote: > Yes, that would be perfect. > > On Nov 3, 2009, at 1:29pm, Mark J. Reed wrote: > >> I'm not clear what you're asking. Given these lines: >> >> a|b|c|d|e|row1col6|row1col7|rest >> z|y|x|w|v|row2col6|row2col7|rest >> ... >> >> What do you want as output? Something like this? >> >> row1col6|row2col6|row3col6|... >> row1col7|row2col7|row3col7|... >> >> >> On Tue, Nov 3, 2009 at 4:08 PM, [log in to unmask] >> <[log in to unmask]> wrote: >>> I need some quick GREP advice. >>> >>> I'm working with a pipe delimited data file in this format: >>> >>> 114|20090826|00:00|N|1800|8005082|6719954|TVPG|L||CC|Stereo|N| >>> Color||N|N|N|4:3 >>> Fullscreen|N||||Y >>> >>> The 6th and 7th items in the each row of data (|8005082|6719954|, >>> from the >>> example) are references to data in other files. >>> >>> So what I need is a grep command that will give me 2 lists, one >>> containing >>> the 6th number from each row and one containing the 7th. >>> >>> The lists could be pipe, comma, tab or return delimited >>> >>> I'm fairly sure this can be done via GREP, but I don't know where >>> to start. >>> >>> Any suggestions? >>> >> >> >> >> -- >> Mark J. Reed <[log in to unmask]>