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.