I am using this write csv method
but I want to specify it so that it is saved as “CSV” instead of “CSV UTF-8”
Right now I think it is saved as “CSV UTF-8” and I can’t upload the file to the platform that only accept “CSV”…
Any idea? Do I have to put something in the Encoding field??
You’re on the right track. Check out the topic for the activity for extra information:
There is a link in there to the list of valid encodings.
Thanks for your respond! I am aware of this page but I am still unsure which one is for just the “CSV”? I see the UTF-8… Any hint? Thanks
I checked the files in Notepad++ and these are the results:
CSV (Comma delimited):
CSV UTF-8 (Comma delimited):
I also found this topic, maybe it helps:
I am trying a create a new file by Create File and Append Line activity. But the issue is it is creating a file with UTF-8 BOM encoding which looks fine in normal editor. But if you lookup that file in Hex editor, it has 3 extra characters at the beginning which makes it unusable. How can I create file with correct encoding UTF-8 without BOM? The Encoding property in Append Line is not helping.
Thanks a lot! I tested different encoding and “us-ascii” works - it saves the csv as “CSV” instead of “CSV UTF-8”
Have a nice weekend
i am also facing same problem i have a csv file which is UTF-8 encoded and i have to convert in into excel but when try with above method all data in single column. how to fix this issue
please help me to fix it