Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Import txt to dw

  1. How-to
0
Votes
Undo
  1. Samuel Sanchez Avila
    Samuel Sanchez Avila
  2. PowerBuilder
  3. Monday, 7 June 2021 15:41 PM UTC

Hello

i was a doing an exercise where i can import csv with dw_1.ImportFile(csv!,path)

But my question is, Its possible to import a txt file with metadata, separate by a ' , ' or  '~' or ' - ' or any other character to a dw?  i have only used this imports with csv...

 

txt metada example

DataA~1~DataC

DataB~1~DataC

DataC~1~DataC

DataD~2~DataC

DataE~1~DataE

 

Thanks guys

Ribbon Bar and XML file deployment
PB 2019 R2 application icon
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 7 June 2021 16:38 PM UTC
  2. PowerBuilder
  3. # 1

Hi Samuel;

   Basically for this, you would need to either:

1) use a FileRead() and then parse the data stream via PowerScript to get the related data out.

2) Create a utility to transform the TXT file into the required CSV format for the ImportFile() command to use.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.