1. 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

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.