Hi,
I have a file abc.txt as
ABC,TYU,1.2566
AHG,GJJ,1.898
hgh,FGA,1.854
My program is reading each line and storing the values variables base_cy, quo_cy, ra_amt
Need to validate each of them as in:
base_cy and quo_cy should be a 3 character alphabet among A-Z, if it is lower case then convert to upper case
and for ra_amt it should be numeric value having only 1 decimal
if all these conditions are met then only proceed otherwise the program should leave this record and move to next one
Please can anyone help me to put this validation.
Thanks in advance.