Hello,
I have the following report (report.txt) file (see attached).
I would like to check the file and if the field is error, then showing error message at output.
- In the report, 1st, 2st and 3nd line can be ignore to check
- start to check line 4 (each field use "," to split
- 1st field should be 5 digits (0-9)
- 2nd field should be A-Z
- 3rd field should be 5 digits (0-9)
- 4th field should be one char (Y or N)
- 5th field should be 00:00 to 99:99 or 0:00 to 9:99
- 6th field should be number or with "."
and so on....(i can do it by myself if you can provide above sample for me) - until last two field, should be 3 char (A-Z)
- At the end of the report, the line should be "*** End of Report *** ,,,,,,,,,,,,,,,,,,,,,,,,"
If any error for each field, just show the line number is ok for me.
Hope someone can help me for this...
Many Thanks!