Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: PowerBuilder
Expertise: Beginner
Jul 27, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Importing Data Containing a CR/LF

How can I import data into a datawindow if the data blob contains CR/LF as part of its data?

I am using dw.object.data and dw.importstring for distributed data transfer. This problem is arising when a user enters data (such as in a note) that contains a new line character in it.

I've tried parsing the string and scanning for CR/LFs and enclosing them in quotes, but this processing is very slow and adds considerably to the transfer times this is performed on as part of a general data transfer mechanism.

Unfortunately, the only way to do this is how you described: using quotes around strings. The way I normally do this is to perform the export myself using a function to extract the data from the datawindow and enclose all strings in quotes.

If you are a pure PowerBuilder shop, then you can also use the Get/Set full state of the datawindow to do distributed data transfer.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date