Re: Select string

[Karen Gunderson <karen.gunderson@DOIT.WISC.EDU>]

Can you use the INSTR function?  If it returns anything but 0, you'll know
'purchase card' is in the record.

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Ben Le
Sent: Monday, October 29, 2001 2:50 PM
To: SQR-USERS@list.iex.net
Subject: Select string


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.