Reading CSV file that has BOM characters

[pmdzuba]

Nothing can read this file in BLS.  I have read that using HTTP Post would allow me to get by these characters but not sure how to use this action.  Is the URL the WEB://proejct file or is that the PostData link.  The file I'm trying to read so I can parse is web://entapps/truck_scales/xmldata/File.csv

[Former Member]

Hi Paul,

Could you please give more details about your requirement. Do you want to read csv data in BLS or just want to extract CSV data via MII and store which can be read later on.

For the time being i can say that using https post you can get data by putting proper url in URL field and out of https(HTTP_Post_0.ReturnAsString) can be stored in file as csv format which you can use later on.

[pmdzuba]

I use FTP input to get the file and save it in my web directory in the xacutexmldata folder.  I need to read this file using BLS but when the text loader fails because of special characters in the file at the beginning.  Pretty sure they are UTF codes and I was told if I could use HTTP Post to open the file, using UTF, I could then use the returnstring to get the data.  The issue I'm having is, I'm not sure what the proper URL string I need to use to get that file and is there any other configuration I need to do for the HTTP Post action block.