You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Read text file(variable columns) in OIC

Received Response
357
Views
1
Comments
edited Feb 18, 2019 5:48AM in Integration 1 comment

Summary

Facing error(Error while reading native data) when reading text file with variable columns in OIC using stage read

Content

Hello,

I have a requirement where I have to modify certain values in BAI2 file from bank and import in Oracle.

BAI2 text file can have different number columns in each row. For example below are three rows of BAI2 file

01,042000314,XYZZ,190201,0244,1,80,1,2/                                        
02,TEXTILE,042100230,1,190130,2359,USD,2/                                    
03,00073972185,USD,010,+0000000000000000,,,015,+0000000000000000,,/ 

Step 1 : Downloaded the file to ICS

Step2: I am trying to read the file(to modify) using Invoke -> Read file option. for Schema I created a sample with maximum number of columns that can come in BAI2 file. All the columns except 1st column were made optional.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!