Numeric conversion in Syncsort

bodatrinadh · Posted: Thu Dec 09, 2010 6:38 pm

I have a delimited input file.

Code:

GTURO|BPH|0002400000312|EQUALIZE||CUR|0.250|XPO
GTURO|BPH|0002400000313|EQUALIZE||CUR|0.250|XPO
GTURO|BPH|0002400000310|EQUALIZE||CUR|0.250|XPO
GTURO|BPH|0002400000311|EQUALIZE||CUR|0.250|XPO

and my desired output is

Code:

GTURO BPH0002400000312 EQUALIZE CUR 00025{XPO
GTURO BPH0002400000313 EQUALIZE CUR 00025{XPO
GTURO BPH0002400000310 EQUALIZE CUR 00025{XPO
GTURO BPH0002400000311 EQUALIZE CUR 00025{XPO

My current sort looks like this:

Code:

SORT FIELDS=COPY,SKIPREC=1
OUTREC PARSE=(%01=(ENDBEFR=C'|',FIXLEN=10),
%02=(ENDBEFR=C'|',FIXLEN=3),
%03=(ENDBEFR=C'|',FIXLEN=13),
%04=(ENDBEFR=C'|',FIXLEN=8),
%05=(ENDBEFR=C'|',FIXLEN=3),
%06=(ENDBEFR=C'|',FIXLEN=3),
%07=(ENDBEFR=C'|',FIXLEN=6),
%08=(ENDBEFR=C'|',FIXLEN=3)),
BUILD=(01:%01,JFY=(SHIFT=LEFT),
11:%02,JFY=(SHIFT=LEFT),
14:%03,JFY=(SHIFT=LEFT),
27:%05,JFY=(SHIFT=LEFT),
37:%04,JFY=(SHIFT=LEFT),
47:%06,JFY=(SHIFT=LEFT),
57:%07,JFY=(SHIFT=LEFT),
63:%08,JFY=(SHIFT=LEFT),66:10X),CONVERT

Thanks
Trinadh

Anuj Dhawan · Posted: Thu Dec 09, 2010 8:12 pm

You already have this similar topic: ibmmainframes.com/viewtopic.php?t=52491&highlight=

Which one do you want to keep?

Arun Raj · Posted: Thu Dec 09, 2010 8:22 pm

Anuj,

I think the TS is only interested in making multiple posts and not in responding to any of the questions asked.

bodatrinadh

By doing multiposting, you are just wasting your own time.