Shell Programming and Scripting

Hello,

I have a file with a lot of record like below:

00001,CUSTR,CUSTOMER ADDRESS,02310,N,0:00,0,0,0,0,0,0,0,0,0,0,0,0:00,0,0,0,0,0,CSH,ACC

Can I validate each record in the file and output the incorrect result?

field 1 - customer number, should be "5 digit.
field 2 - should be 5 string, no number
field 3 - customer address - any string, number or space
feild 4 - inovice number - should be 5 digit.
field 5 - should be "N' or "Y"
field 6 - process time, should be "mm:ss"
field 7 to 17 - digit
field 18 - end process time, should be "mm:ss"
field 19 to 23 - digit
field 24 - 3 string (A to Z)- no blank, no "?"
field 25 - 3 string (A to Z) - no blank

Here is error sample:
00001,CUSTR,CUSTOMER ADDRESS,023a0,N,1,0,0,S,0,0,0,0,0,0,0,0,12:15,0,0,0,0,0,?,

the error report will look like:
record1:field 4,field 6,field9,field24,filed25

thx!!

hello,

I have a record below and would like to change the time fromat from m:ss to mm:ss

input
00001,CUSTR,CUSTOMER,02310,N,0:00,0,0,0,0,0,0,0,0,0,0,0,0:00,0,0,0,0,0,CSH,
00001,CUSTR,CUSTOMER,02310,N,5:12,0,0,0,0,0,0,0,0,0,0,0,1:10,0,0,0,0,0,CSH,

output
00001,CUSTR,CUSTOMER,02310,N,00:00,0,0,0,0,0,0,0,0,0,0,0,00:00,0,0,0,0,0,CSH,
00001,CUSTR,CUSTOMER,02310,N,05:12,0,0,0,0,0,0,0,0,0,0,0,01:10,0,0,0,0,0,CSH,

Use perl for this. I think it would be easiest. I don't have access to a test system, so can't give you an example, but basically, read from STDIN, split the line into an array with the ',' as the delimiter. Then use regexes to match your patterns.

Try:
sed 's/,\([0-9]:[0-9][0-9]\)/,0\1/g' data

Assuming "data" is a file with the input.

Both threads are referring to the same problem, so I have merged them. You can follow the same directions, just that when you get to the field with the time, if it is x:xx, just add a leading '0'.

can you provide an example for me?

thx!

anyone can help for this?