getting account number invalid format using icetool
Posted: Tue Feb 12, 2019 2:09 pm
Hi All
iam using below code to get the results in csv file but getting phone number invalid format
could you please help to get correct format for account number.remaing fields are getting correct format but issue with thie field
INREC FIELDS=(1,200)
OUTFIL FNAMES=FNLCSV,
BUILD=(3,15,C',',19,3,C',',23,1,C',',
C'"',26,2,C'"',C',',
30,30,C',',62,8,C',',
72,8,C',',
C'"',80,15,C'"',C',',
98,44,C',',
C'"',142,5,C'"',199:X)
output:
iam using below code to get the results in csv file but getting phone number invalid format
could you please help to get correct format for account number.remaing fields are getting correct format but issue with thie field
INREC FIELDS=(1,200)
OUTFIL FNAMES=FNLCSV,
BUILD=(3,15,C',',19,3,C',',23,1,C',',
C'"',26,2,C'"',C',',
30,30,C',',62,8,C',',
72,8,C',',
C'"',80,15,C'"',C',',
98,44,C',',
C'"',142,5,C'"',199:X)
output:
phone NUMBER
710020937
1.40402E+11
1.41442E+11
1.41942E+11
1.41942E+11
2.26921E+11
2.26923E+11
2.26923E+11
3.20872E+11
3.21047E+11
3.23422E+11
710020937
1.40402E+11
1.41442E+11
1.41942E+11
1.41942E+11
2.26921E+11
2.26923E+11
2.26923E+11
3.20872E+11
3.21047E+11
3.23422E+11