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

Number format conversion (".," to ",.") using SQL in Data Management

Received Response
11
Views
4
Comments
edited Aug 18, 2021 9:14AM in Planning 4 comments

Summary

Converting amounts in Data Management from EU to US notation via SQL script

Content

Hi everyone!

Is there a way to change the number format in a value in Data Management via an SQL mapping? Since I'm getting several data files with different number formats/delimiter settings, I'd like to check for this via SQL script and turn this around if necessary. 

I realize it would be easier to make sure everybody adheres to the same file convention, but it is what it is. And since I'm getting files with different settings, I cannot use Fill=EuroToUS for obvious reasons.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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