Question Record delimiter on EXPORT

[ron]

Hello,

We're using 10.1B. (OLD! Yes, I know.)

I have to export full tables in csv format to give to a third party. Some of our CHAR fields contain new-line characters - which completely bamboozles them - even though they are quoted.

As far as I can see OpenEdge supports choosing a field separator - but not a record separator. Does anyone know of a way to achieve this?

Ron.

 

[Osborne]

I suppose one way would be to use a dynamic export and remove the new-line characters from the text before exporting:

Progress KB - How to EXPORT a record dynamically.

 

[ForEachInvoiceDelete]

If they cant import line by line as a record seperator do this.

FOR EACH bla NO-LOCK:

EXPORT DELIMITER "THIS-IS-THE-FIELD-DELIMITER-I-USE-SO-DEAL-WITH-IT" bla.

PUT UNFORMATTED "THIS-IS-THE-RECORD-DELIMITER-I-AM-USING-SO-DEAL-WITH-IT" SKIP.

END.

The file will look like crap but if they are reading it into a big ass string it wont really matter.

 

[tamhas]

You need some interaction with the recipient ... what do they actually want you to do with the new lines? If they want to preserve them, then mutually pick a character to substitute and replace on export and reverse replace on import. If they can't actually handle them at all, then decide what they want to do ... replace with another character that will just be understood as new line or whatever?