Link to home
Start Free TrialLog in
Avatar of ibgadmin
ibgadminFlag for United States of America

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.
Avatar of Bill Prew
Bill Prew

Can you provide a sample file ?

~bp
Avatar of ibgadmin

ASKER

Sure thing - here you go
invfeed.csv
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Bill, this ran perfectly.  Thanks so much!
Welcome, thanks for the feedback.

~bp
Bill is there any way this can be run where the parm1 and parm2 files can be a unc path?
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.)."
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