I want to test a field using the following validation pattern :
- first position should be '+' or numeric
- all other positions should be numeric or spaces. If this is not the case, all positions within the field should become spaces.
Furthermore, in the output record, the field should be squeezed to the left and remain 10 positions (trailing blanks).
Syncsort version used = 18.104.22.168R
Input record consists of a five position key (which has to be kept), a ten position field (for which the conditions as described above should apply) and a five position field (which has to be kept).
Example input record :
key02123 56 8 aaaaa
Desired output record :
I have tried a number of combinations using PARSE and SQZ, but none with the desired results. Any suggestions?
Thanks in advance!