I AM ADDING A SEQUENCE NUMBER TO INPUT FILE IN FIRST FIVE DIGITS
AND I AM FORMATING THE SEQUENCE NUMBER TO GET COMA SEPEARED VALUES AND WITH STRIPPED ZEROES.
THE BELOW ONE IS GIVING CORRECT RESULT BUT MY SEQUENCE NUMBER IS COMING STARTING AT '3 rd COLUMN ' .
CAN ANY BODY HELP ON THIS?
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
You're using the M12 mask for a 5-byte UFF field. This gives an output value of 'SII,IIT'. So for sequence number 1, you would get 'bbbbbb1' (b for blank). For sequence number 12345, you would get 'b12,345'. You need to use the correct edit mask to get what you want, but since I don't actually know what you want, I can't tell you which edit mask to use.
What is it exactly that you want the output field to look like for the following sequence numbers
hi frank ,
in the input file between 1 TO 5 i have some sequence numbers , now i want to reformat them (ie i want to give new sequence numbers startting from one and oytformat should be in UFF Format).
output:
8,003
8,004
8,005
8,006
8,007
8,008
and it should be between 1 and 5 positions only.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
For values like 8,003 you could use EDIT=(T,TTT) or EDIT=(I,IIT) as the edit mask instead of M12 depending on whether you want leading zeros shown or not.