csv character

[David Jondreau]

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?

[Kris M]

I think that block = carrage return

[RalphL]

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?

[David Jondreau]

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.

[RalphL]

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.