Re: Select string CLOSED - got it

[Ben Le <ble@PCC.EDU>]

Thanks to Karen, Kenny and Sunitha. All your replies are working. You all
give me a direction where/how to go with it. You all are great.
This subject is closed.

At 03:42 PM 10/29/01 -0600, you wrote:

>Ben,
>
>Try using Find and Extract or
>Substring or what ever you want to do commands;
>
>Read [n] into $Row
>
>Find 'purchase card' in $Row 0 #loc
>
>if #loc != -1
>
>        substring($Row, #loc, 13)
>
>
> >From: Ben Le
> >Reply-To: sqr-users@list.iex.net
> >To: SQR-USERS@list.iex.net
> >Subject: Select string
> >Date: Mon, 29 Oct 2001 12:50:20 -0800
> >
> >I am reading a flat data file. For each line in the data file I
> >would like
> >to select only the word 'purchase card'. It seems simple to do. But
> >I can't
> >figure out how to do it in SQR. Help please!
> >exp:
> >book 2000 20-sep-01 purchase card $20,000
> >invoice purchase card $25.50 account payable
> >...
> >'purchase card' word is not always in the same column of the data
> >file.
> >Thanks in advance.
>
>
>----------
>Get your FREE download of MSN Explorer at http://explorer.msn.com

Benjamin Le
ITS, System Development
Portland Community College
12000 SW 49th Ave. Portland, Oregon 97219
(503)-977-4970    Fax:(503)-977-4987
Mailto:ble@pcc.edu      http://www.pcc.edu