Importing/exporting data with carriage returns (I Think)

Mike Fedkiw mfedkiwfp at gmail.com
Fri Aug 25 09:33:25 PDT 2017


win-server 2008 r2/filepro 5.0.09dn9

Can someone tell me how or what I can do to import data into filepro 
that has carriage returns within the data cells?

I receive these nice XLS files from my vendors with extended 
descriptions for things that I want to get into a memo fields in filepro 
but I'm having all sorts of issues trying to make that happen.

Usually after setting up the XLS file to the way it needs to be for the 
import I'd save it as a DXF file. That's been working just fine for 
quite some time but when a cell contains returns I get an error message 
saying it's not a valid DXF file. I also tried saving it as a CSV file 
and importing that but the cells with the returns didn't import at all 
when I tried that. And I'm not even sure I'm saving it as the correct 
type of CSV(Comma delimited CSV or MS-DOS CSV) for importing it.

Even if I get the import figured out if the data does have and returns 
within the memo it seems to stop exporting that fields data after the 
first one.

If at all possible, I would really like to maintain the returns because 
it makes it much easier to read the data in the memo and it would also 
make the exported data much nicer too read with them included.

AND...instead of me sitting here trying to figure this out for another 
week or so like I just did with all the MEMO stuff, I'd just assume pay 
someone to set it up for me. If someone is interested in doing that, let 
me know.



Mike







More information about the Filepro-list mailing list