I have .csv file coming into the engine. I’m looking for a script that removes the header (first line) of the file. Please share the script if you’ve done this before…
I do have a script that builds Cloverleaf Tables from delimited files and that has a provision for removing headers.
However, one way I would attack this, off of the top of my head, is to use the DirParse UPoC and have Tcl code there that will take the file name from the list then read that file and create a new file (same name same location??) without the first line. If I wrote this proc I would give it an argument that specifies how many leading records are to be treated as header records. This is because some tools can xport multiple records as headers not just one.
Then return the file list to Cloverleaf and it will now read the file without the first line.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.