Read .txt(position based file) to CSV file In OIC.
SummaryReceiving Positioned based file from SFTP and need to create CSV file.
Need suggestions on how to read .txt(position based file) file to csv. As of now am taking variables to read each field with substring. but some fields are not getting correct values.
Ex: txt file line: 30000000000142550028400001000102001393 0000000004120005212020CHKUSDG-4974011
if i use substring (c1, 62,69). i should be getting 5212020' but am getting '05212020CHKUSD'.
And Spaces also causing issue in reading.
Is there any other method to read?