RE: Searching IFS stream file for string and returning position

You can determine the position in an IFS File with SQL and the
GET_CLOB_FROM_FILE Scalar function.
If you want to check the content case insensitive, just put UPPER or LOWER
around:

The following statement returns the position of 'searchstring' in the
/home/Dir1/Dir2/YourIFSFile.txt case insensitive.
Values(Locate('searchstring', Lower(Get_CLOB_FROM_FILE('/home/Dir1/Dir2
/YourIFSFile.txt'))));

Mit freundlichen Grüßen / Best regards

Birgitta Hauser


"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jose Perez
Sent: Dienstag, 29. Dezember 2020 17:11
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Searching IFS stream file for string and returning position

sql can read ifs check below example

SELECT * FROM TABLE(QSYS2.IFS_READ(PATH_NAME =>
'/home/MyFolder/test.txt'))

however your version of OS need to be on *Db2 for i* *IBM i* 7.4 TR3 or 7.3
TR9.


On Tue, Dec 29, 2020 at 11:02 AM Jack Woehr
<jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

On Tue, Dec 29, 2020 at 9:00 AM Jack Woehr <
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

On Tue, Dec 29, 2020 at 8:56 AM Brad Stone <bvstone@xxxxxxxxx> wrote:

Hey, all.

Just wondering if there are any tools one can use to search a
stream

file

for a string and return the position of the string where found.
(case insensitive would be best)

Perl. Python. Java. C/C++. Welcome to regex land.

Play with grep a bit to see how this works.

--
Jack Woehr
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you
received this communication in error, please contact the sender and
delete/destroy all copies of this communication immediately.
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com