| jayakanthang |
| Newbie |
|
| Singapore |
|
|
| None Specified |
|
| Friday, June 12, 2009 |
| Wednesday, July 8, 2009 10:09:26 AM |
4 [0.02% of all post / 0.00 posts per day] |
|
Hi
Thanks for your reply. Can you give me an example, how to use sort utility?
|
Hi,
I converting XML file to CSV file. In CSV file i have following columns
JOB_NO,CNTNR_NO,HBL_NO,GROUP_NO,WEIGHT_GROSS JOEC900961,OOLU6400830,OCGLA900029,1,300 JOEC900961,OOLU6400830,OCGLA900030,1,480 JOEC900961,OOLU8233794,OCGLA900031,1,202 JOEC900961,OOLU8233794,OCOLA900004,1,1100.2 JOEC900961,OOLU8233794,ODALA900009,1,238.4 JOEC900961,OOLU6400830,ODMLA900002,1,3915 JOEC900961,OOLU8233794,ODTLA900012,1,297.6 JOEC900961,OOLU8233794,OLALA900123,1,1273 JOEC900961,OOLU6400830,OLALA900126,1,308 JOEC900961,OOLU6400830,OLALA900127,1,993 JOEC900961,OOLU6400830,OLALA900128,1,99.9 JOEC900961,OOLU8233794,OLALA900129,1,381
If I want order by jobno, contnr_no, hbl_no, how to do? Anyone can assist??
Thanks
|
Hi
Thanks for your reply. But unfortunately I don't understand what you mean?
Can you give an example to map my scenario?
Thanks
|
Hi
I am having problem to map like as follows
DELIMITED INPUT FILE ---> TEXT FILE WITH BELOW FORMAT
my input structure as follows
"D"~CSI DESC1 - I1~CSI DESC2-I1~CSI DESC3-I1~|MARKS-H1-I1 "I"~2~200~100~200.0~PCS~~ "E"~IJKL1234567~H1-I2-003~~~~~~~L~ "D"~CSI DESC1- I2~CSI DESC2-I2~CSI DESC3-I2~|MARKS-H1-I2 "I"~3~100~100~200.0~PCS~~ "E"~IJKL1234567~H1-I2-003~~~~~~~L~
"D"~C1-I3~C2-I3~C3-I3~|M1~M2~M3~M4~M5~M6 "I"~3~100~100~200.0~PCS~~ "E"~IJKL1234567~H1-I2-003~~~~~~~L~
I want an output like as follows
1 CSI DESC1 - I1 MARKS-H1-I1 2 CSI DESC2-I1 BLANK 3 CSI DESC3-I1 BLANK
1 CSI DESC1- I2 MARKS-H1-I2 2 CSI DESC2-I2 BLANK 3 CSI DESC3-I2 BLANK
1 C1-I3 M1 2 C2-I3 M2 3 C3-I3 M3 4 BLANK M4 5 BLANK M5 6 BLANK M6.
Can anyone advise how to achieve this result?
|
|