Re: can sql update a non database ascii text file in IFS

Hello Kevin,

Am 13.01.2020 um 22:55 schrieb Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>:

Yes. But he wants to take a portion of the line he is reading, get a record from that file based on the portion of the line, and use a value in that file for his replacement value. It's not a replace xx with yy situation.

Sorry, then I misunderstood your comment. What you write sounds like a scenario for awk but I'm not fluent with it.

Funny fact: Awk has been compared to ancient RPG versions, because of the implicit cycle logic. Awk also reads until EOF and does stuff with the data. :-) I can't recall where I read that, though.

:wq! PoC

PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc