MACSCRPT Archives

November 2009

MACSCRPT@LISTSERV.DARTMOUTH.EDU
Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

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

Print Reply
Mime-Version:
1.0 (Apple Message framework v1076)
Content-Type:
text/plain; charset=us-ascii; format=flowed; delsp=yes
Date:
Tue, 3 Nov 2009 13:08:02 -0800
Reply-To:
Macintosh Scripting Systems <[log in to unmask]>
Subject:
GREP help
From:
"[log in to unmask]" <[log in to unmask]>
In-Reply-To:
<[log in to unmask]>
Content-Transfer-Encoding:
7bit
Sender:
Macintosh Scripting Systems <[log in to unmask]>
Parts/Attachments:
text/plain (20 lines) 
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?

ATOM RSS1 RSS2