I have a whole bunch of files in a folder, and want to merge them to a csv file. The one I want to merge have a name format of Proc_Account.txt or Proc_Sales.txt etc They are all text files delimited by |. Example of file.
Frank | Albert | M | 01/05/1974 12:00 | 808 Genstone Ave | 23UYTLY
What I want is to append all the files in the folder to 1 csv, but I want to process each line where, I change the date format from 01/05/1974 12:00 to 19740501.