- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Is there a way to save JMP table as UTF-8 encoded csv without BOM?
I use JSL to extract and transform a variety of data sources into one consolidated csv file that I output to our BI platform. I found this week that the latest csv output didn't work and the BI platform is indicating it is an encoding issue. Opening previous versions of the csv files in Notepad++ I can see they are encoded using UTF-8. However, the newer csv file is encoded as UTF-8-BOM. I don't know why it changed and is there a way to specify saving a JMP table as a csv without the BOM?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Is there a way to save JMP table as UTF-8 encoded csv without BOM?
Jump adds the BOM, (bite order mark ), because there is a character outside of the 7-bit ASCII range. That means you have a unicode character in one of your strings. One way to remove the bite order mark would be to load the file into a blob, remove the first three bytes with blobpeek, and then rewrite the file from the blob. Load/save textfile() is the function you need, look for the blob option.
Edit textile->textfile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Is there a way to save JMP table as UTF-8 encoded csv without BOM?
Jump adds the BOM, (bite order mark ), because there is a character outside of the 7-bit ASCII range. That means you have a unicode character in one of your strings. One way to remove the bite order mark would be to load the file into a blob, remove the first three bytes with blobpeek, and then rewrite the file from the blob. Load/save textfile() is the function you need, look for the blob option.
Edit textile->textfile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Is there a way to save JMP table as UTF-8 encoded csv without BOM?
Thank you, Craige. That worked. I didn't need to use the Blob Peek function as the Load Text File included the option to skip the first three bytes:
Load text file( myFilePath , BLOB(ReadOffsetFromBegin(3) ))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content