Dear All

I have a following program to extract pipe delimated data, but I want to
select only some columns how to do that? and how to split output file after
some records ( ie 10000 or 20000 ) .
-------------
OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'CUSTOMER.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
READ REC FROM FIL,ID THEN
LINE = '' : CHANGE(CHANGE(REC,@AM,'|'),@VM,'|') : '|':ID
WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
END
REPEAT
---------------

Regards
Dattatraya

-- 
View this message in context: 
http://old.nabble.com/How-to-Extract-Selected-multivalue-colums-tp26569624p26569624.html
Sent from the U2 - Users mailing list archive at Nabble.com.

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to