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:
Reply To:
Macintosh Scripting Systems <[log in to unmask]>
Date:
Tue, 3 Nov 2009 14:22:09 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (47 lines)
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]>

ATOM RSS1 RSS2