Jump to content
Sign in to follow this  
David Jondreau

csv character

Recommended Posts

I'm exporting a list of item numbers to a file. I'm sending the file to a web developer who's adding it to a web site.

The web developer insists the list be a comma-separate file. I've wrote the script and done the export, but the web developer says there's an extra character is showing up in the export. I don't see it when opening the file in TextEdit (OS X Tiger).

I've tried every English-language character set: Macintosh, Windows, ASCII, UTF-8, and UTF 16 and he says he's still getting the character which is showing as a single block. He says it has a hex value of "1d".

Any ideas on how to get rid of this character?

Share this post


Link to post
Share on other sites

I'm exporting a list of item numbers to a file. I'm sending the file to a web developer who's adding it to a web site.

The web developer insists the list be a comma-separate file. I've wrote the script and done the export, but the web developer says there's an extra character is showing up in the export. I don't see it when opening the file in TextEdit (OS X Tiger).

I've tried every English-language character set: Macintosh, Windows, ASCII, UTF-8, and UTF 16 and he says he's still getting the character which is showing as a single block. He says it has a hex value of "1d".

Any ideas on how to get rid of this character?

"1d" = 29 base 10. That is the separator used in repeating fields. Do you have any repeating fields?

Share this post


Link to post
Share on other sites

Yes! The field is a repeater (2 reps, only first one matters, long story). Is there a way to get rid of it?

I know I can create a calc field for the export that grabs the rep, but I'm wondering if there's a way to just strip it out.

Share this post


Link to post
Share on other sites

A file plug-in might work to remove the ASCII 29 characters. I think the calculation would be easier. Best get rid of repeating field for data.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.