David Jondreau Posted February 2, 2009 Share Posted February 2, 2009 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? Link to comment Share on other sites More sharing options...
Kris M Posted February 2, 2009 Share Posted February 2, 2009 I think that block = carrage return Link to comment Share on other sites More sharing options...
RalphL Posted February 2, 2009 Share Posted February 2, 2009 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? Link to comment Share on other sites More sharing options...
David Jondreau Posted February 2, 2009 Author Share Posted February 2, 2009 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. Link to comment Share on other sites More sharing options...
RalphL Posted February 2, 2009 Share Posted February 2, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5562 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now