Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert Decimal Separator From comma to Dot.

user8819264Dec 6 2013

I use FDM with Pull adaptor (.txt File to .txt File) to convert the format of the source .txt file

My source data comes with format '887722,50'  When i import the file I see the format like '887722.50' on the FDM Screen. But export the output file it gives me on the format '887722,50'.

I have tried with option Fill=EuroToUs. But during the import it says 'Error: Import failed.Invalid data or Empty content.'

Can anyone help me in getting the output file in  this ('887722.50') format

My Decimal Replacement is set to 'none' in configuration setting. (However i have changed this to all available options and found no change in the output file).

My Regional option is English United States.

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 3 2014
Added on Dec 6 2013
#business-intelligence-applications, #financial-data-management, #performance-management-applications
0 comments
288 views