ibgadmin
asked on
How to remove BOM hex characters from csv file
Does anyone have any help on how to remove BOM (EF BB BF) hex values from the beginning of a csv file? I have a static csv file that is generated daily and I need to remove those hex values which are at the beginning of the file only. Not a VB programmer but that would work best for automating to run daily on our server.
ASKER
Sure thing - here you go
invfeed.csv
invfeed.csv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bill, this ran perfectly. Thanks so much!
Welcome, thanks for the feedback.
~bp
~bp
ASKER
Bill is there any way this can be run where the parm1 and parm2 files can be a unc path?
ASKER
Actually Bill my issue is that the script provided worked fine on my Win7 machine but not on Windows Server 2003. Do you happen to know why? I get a Windows Script Host error - "Execution of the Windows Script Host failed. (The parameter is incorrect.)."
ASKER
Please disregard my two previous comments. This script works fine on Windows Server 2003 as well as unc path's for the parms
Okay, good to hear.
~bp
~bp
~bp