This looks a bit dangerous.
It is converting all @AMs and @VMs to pipes. This is assuming that the number
of AMs and VMs will be consistent for each REC - a very bad idea in general
considering the whole concept of multi-values (and for that matter,
multi-attributes).
To extract just specific fields (attributes), you will need to add more lines
of code to only grab those fields, and then write this out to your CSV file.
For example:
LINE = REC<1>
LINE<-1> = REC<4>
LINE<-1> = REC<8>
...
CONVERT @FM TO "|" IN LINE
WRITESEQ LINE ON CSVFIL ...
Again, this does not cover the issue of multi-values. If field 4 of the first
record has 1 multi-value, but field 4 for the 2nd record has 10 multi-values,
then using a pipe for a shared delimiter will make the export almost completely
worthless. You might want to convert AMs to pipes and convert VMs to tildas
(~) or some other ASCII delimiter, however, that will be us to you and your end
user.
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OHÂ 45342
937-866-0711 x44380
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Dattatraya
Sent: Monday, November 30, 2009 12:01 AM
To: [email protected]
Subject: [U2] How to Extract Selected multivalue colums
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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
