I am getting a file from a client which I assume is coming from a mainframe and is being transfered over to a unix box. I am running the file through sql-loader to populate an Oracle table. The field I am having a problem with is being moved to fields depending on which code it is. The position of the field is:
tbelec position(027:033) "nvltbelec ,'0')" ,
The problem is the input from the ftp'd transfer file has an ascii character and I cannot for the life of me figure out how to make Cobol get rid of it. Here is what some of the fields look like. It does not always have acharacter at the end.
0000400
000020p
0000400
000020p
0000084
0001500
000013s
000020p
0000400
0015000
0001000
Any ideas on how to fix this? Thank you!
tbelec position(027:033) "nvltbelec ,'0')" ,
The problem is the input from the ftp'd transfer file has an ascii character and I cannot for the life of me figure out how to make Cobol get rid of it. Here is what some of the fields look like. It does not always have acharacter at the end.
0000400
000020p
0000400
000020p
0000084
0001500
000013s
000020p
0000400
0015000
0001000
Any ideas on how to fix this? Thank you!