Vaughan Posted March 19, 2004 Posted March 19, 2004 That's because CSV format does not permit carriage returns within fields themselves, because they are reserved for "end of record" characters. Try exporting as html.
CyborgSam Posted March 19, 2004 Posted March 19, 2004 Are you using a Mac? If so: I wrote a program for OS 9 that takes tab-delimited FileMaker exports and converts fields to lines. I just recoded it into an AppleScript for OS X last weekend. If you use Windows, I could see how hard it will be to port it (the algorithm is very simple). Let me know if you want it.
BobWeaver Posted March 19, 2004 Posted March 19, 2004 The only problem is that the resulting file likely won't be compatible with anything. A linebreak character will still indicate End-of-Record to the program that eventually imports the data. Maybe, if the field is enclosed in quotes it might work.
LoneReaper Posted March 21, 2004 Author Posted March 21, 2004 I am using a program called autoit www.hiddensoft.com It changes the file and makes it exactly as i need it. It is an amazing program once you learn how to use it.
Recommended Posts
This topic is 7553 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