Hi All

I am having one text file separated with Tab or say "|". How can I get this data into BaaN Table.

I am using BaaN IV c4 on Win Nt with Oracle 8.0.5 database.

-Mohan

Use Exchange Scheme.

Link (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7374&highlight=Exchange+Scheme)

If the structure of the asci file fits exactly to the table you want to fill (each field exists, empty one like || (two seperators), then you can use bdbpost6.1 directly.
call bdbpost6.1 -U to look for options or use the session "create table from sequential dump"
rename the file correctly, for example if you want to fill tccom010 in company 555, the name has to be
ttccom010555.S

hth

Norbert


P.S.: Try this in test environment first!!!

Dear Mohan,

If your file is separated with "|" then bdbpost, exchange and ttaad4247m000 can help you, subject to structure of table. But if your file is separated with Tab then, I think seq.open, seq.gets, string.scan, seq.close functions, is the only way.

-Suhas

I have to disagree with Suhas:
Baan bsdpost/bdbpre accepts any separator (as long that they do not interfere with field data), so tab ("\9" if i'm not mistaken) or "|" is ok (see the -t option from bdbpost).

Thanks all

I got it through bdbpost.

-Mohan