AnsweredAssumed Answered

Exception occured, trying to process CSV File

Question asked by paparao.mudraboyina158839 on Jan 8, 2018
Latest reply on Jan 9, 2018 by mmorthala189353

Dear Folks,
I am trying to process the CSV file from SFTP to Database
My file format is like this
ABC|MNR|C|1000|121000248|0123456789|909082288||160105~
I did choose Pipe delimeter while creating FlatFileProfile
Here 160105 is EffectiveDate(as per CSV file).
So in FlatFileProfile, I did set DataFormat Options:
Date type: Date/Time
Date Format : ddmmyy
While executing , i am getting exception as
Test execution of CSVFileProcess completed with errors. Embedded message: [Input ProfileLocation: Record/Elements/EffectiveDate; DocumentLocation: Record (2,0), FileRow 2]: Error Parsing Date '160105~', Expected Format ddmmyy: Failed parsing '160105~' due to extra trailing character(s) '~'; Caused by: Error Parsing Date '160105~', Expected Format ddmmyy: Failed parsing '160105~' due to extra trailing character(s) '~'; Caused by: Failed parsing '160105~' due to extra trailing character(s) '~'

For resolving this I did used String Remove transform function like this
Original String :   EffectiveDate
String to Remove:   ~
cashing selected:   By Map
and then the result map to target element EFFECTIVE_DATE(database element)

 

While executing again , Still I am getting same above exception
Appreciate your help for the same.

Thanks,
Rao

Outcomes