I have a customer with a point of sale system that uses text files transferred to vendors to send data back and forth. Long story short, we need to change the data in one column of several (like 30) text files from one number to another on every line (record) in each file. But, it's only for the one column...the number that we're changing from may be in another column in the file and that would need to stay as is. Oh, and the column number in question is different for each file. i.e., for file1, it may be column1. for file2, it may be column4. I was looking at the following utility:
but frankly, I got lost pretty quickly...maybe I didn't dig deep enough into the help for each different function, but there were so many functions and I didn't really know which ones I would need...
Any help would be greatly appreciated!!