Hi All,
We are receiving multiple .csv files from BIP server and other applications but due to multiple comma(,) separation we are missing number of lines and data to be load into the datastores .
so I got one command which is given below that resolved our problem so I ran it before data load into datastore using linux terminal.
awk -F'"' '{gsub(",", "", $2);print}' filename.csv
Now I have use ODI package to automate the same command using ODI tools before load the .csv file data into datastore and also rename the file.
So could you guide me please how I can achieve it using ODI package tools step by step.
Thanks