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
Feb 22, 2000

How to Load Data from TXT Files

Question:
How do I pick up useful data from a TXT file and insert it into a database?

Answer:
You can tackle this problem two ways. If your data follows a structure (for example, it's comma-delimited) then you can use the standard PowerBuilder ImportFile command to load the data directly into a datawindow and then update the datawindow to add the data to a database.

If the data is more complex and not structured then you can use the FileOpen | Read | Close commands to read the data into a local string variable. Extract the data, load it into a datawindow, and then update the datawindow to add the data to the database.

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