Search Results

I have a pipe delimited file that I need to 'mask' to before loading to keep some data confidential. I need to maintain the first 4 bytes of certain columns and replace the remaining bytes with an...

Interesting, didn't know that was an option for FS. Unfortunately my input file is fixed length and I'm doing a bunch of substr's to pull out the data I need. I said | in my original question just...

This worked perfectly. Thanks alot for your time.

One other quick question if I could. If I have to trim white space from a column, is there a way to do that with printf? I was able to do it...

I've done quite a bit of searching on this but cannot seem to find exactly what I'm looking for. Say I have a | delimited input file with 6 columns and I need to change the value of a few columns...