Overlaying specific characters using SYNCSORT

raam_kumar · Posted: Fri May 25, 2007 10:04 am

Hi
I have the following requirement

Input:

100B1 20
100B1F20
100B1 20
100B1 20
100B1F20
100B2 30
200B1G10
300B2 10
300B2H10
300B2 10
300B2 10
..
..
..
Output:

100B1F20
100B1F20
100B1F20
100B1F20
100B1F20
100B2F30
200B1G10
300B2H10
300B2H10
300B2H10
300B2H10
..
..
Can this be achieved using SYNCSORT?

murmohk1 · Posted: Fri May 25, 2007 10:20 am

Raam,

Elobrate your requirement as your example doesn't convey anything (except change in few records with value F or G or H).

raam_kumar · Posted: Fri May 25, 2007 10:34 am

Hi
I have to compare position's 1-3 and 6. The input file will contain different values in position's 1-3. each value at position 1-3 will contain either a alphabet or spaces at position 6. (the alphabet is constant for that particular value). I have to replace the spaces with that alphabet .

For Eg: if value of Pos 1-3 is 100. it may contain either 'F' or spaces at position 6. The requirement is i have to replace all the spaces at position 6 for value 100 by 'F'

dick scherrer · Posted: Sat May 26, 2007 4:28 am

Hello,

You might consider ignoring the spaces.

If i understand, when pos 1-3 is 100, pos 6 must always become an F - if 200 pos 6 must always become a G - and so on.

If you only check for the 100, 200, etc and move the appropriate letter, you should get the desired result.

Again, this is only true if i understand the requirement.