MACSCRPT Archives

November 2009

MACSCRPT@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Mark J. Reed" <[log in to unmask]>
Reply To:
Macintosh Scripting Systems <[log in to unmask]>
Date:
Tue, 3 Nov 2009 16:29:02 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (38 lines)
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]>

ATOM RSS1 RSS2