Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

Importing Data Containing a CR/LF

Question:
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.

Answer:
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.

 

 

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