Import the text file

tonypang

hello all master here,

Do you know how to write the code unit to read the text file with a comma separator
save it the data to table ?


Hope master here can help me.
Thanks

bangswit

using file


File.TEXTMODE(TRUE);
File.WRITEMODE(FALSE);
File.OPEN('C:\Test.txt');
File.Read(Vstring)

vstring set as a text

tonypang

For example if my text file format as follow
how to read the field by field ?

AAA|BBB|10
BBB|CCC|20

For your code i only can read the whole string
How to chop it out field by field

I need to result like
Field 1 : AAA
Field 2 : BBB
Field 3 : 10

bangswit

why don't you use dataport?

tonypang

because the user prefer auto run import function.
later on need to populate the data to table..
Before that need to do some validate the checking.


because if using the data port user need to browse the file where they save ?
Am i right ? then run it manually.

If i write in code unit all the function can be call and use it.
Right?


Anyway thank you for quick respone.

bangswit

if you have default path in dataport, just add this code

Dataport - OnPreDataport()
CurrDataport.FILENAME := 'C:\YourFileName.txt';

tonypang

ok. Thanks