Skip to Main Content

APEX

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!

DataLoad Decimal Character, Group Seperator issue

Jake4321Apr 27 2020 — edited Jun 17 2020

Hi all,

currently working with Application Express 19.2.0.00.18.

I am working in a multi-lingual environment English-French.

As such I have to handle imports of csv files that might be encoded with what we call "imperial notation" Decimal character (.) and Group seperator (,) or "european notation" Decimal character (,) and Group seperator being (space).

Here are two typical Windows setup users might have: Depending on the workstation Windows setup the csv file might contain either imperial notation or european notation.

Data csv FR-CA.JPG

Param_windows CA-FR2.JPG

My expectation is I could override the different notation by using advanced setting in the Dataload import Wizard as shown below:

APEX_DLW_param.JPGAPEX_DLW_param2.JPG

But it appears that I can only succefully load imperial notation csv files, reading european notation parsing dows not work:

DLR3_CA-FR.JPG

Anything I am doing wrong?

As usual, any tips comments, suggestions are greatly appreciated.

Thanks,

Jake

This post has been answered by Jake4321 on Aug 17 2021
Jump to Answer
Comments
Post Details
Added on Apr 27 2020
2 comments
134 views