getting account number invalid format using icetool

[thotlma]

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

Code: Select all

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:

Code: Select all

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

[Garry F Carroll]

It would be helpful if you could provide a sample of the input dataset, the RECFM and LRECL. At which position in the input is the phone number? Is the output you show for one or more records?

Garry

[thotlma]

Thanks Garry for responding this one
record length=200 and RECFM=FBA
please see the below example 1 record

Code: Select all

00000712340837 ,FDA,2,"02",HELD FOR COLLECTION           ,02/07/19,02/111/19,"         800.00",REASONABLE CAUSE REGCC 1                    ,"03200"

Coded to maintain correct presentation of data. Do it yourself next time.

[enrico-sorichetti]

it would have been wiser to post the records corresponding to the data in the initial post
so that the people answering might have been able to explain the different behaviour

[Garry F Carroll]

I can't replicate your results. Can you show the job and the control cards you are submitting?

Garry