Converting numbers to decimal dot, and comma separated

[gpbarsky]

Hi my friends...

I need to convert a number which represents an import, and instead of showing $9,876.54 I need to show $9.876,54. I mean, I ant my decimal point to be the comma ',', and the thousand separator to be the dot '.'.

I am using the Oconv function with the format MD2,$, but I'm getting the numbers in the other way around.

Thanks in advance, and have a nive day.

[ArndW]

This looks like you are trying to make the number look German. Without having NLS enable, try OCONV('1234567','MD2["$",".",",",""]')

[DSguru2B]

gpbarsky, you need to bring your input into plain numeric format before using ArndW's code. So all together your expression will look like this

Code: Select all

Oconv(Iconv(in.Col,"MD2$"),'MD2["$",".",",",""]')

[narasimha]

Thats a tricky one.
A little Math can also help here.

Code: Select all

Ereplace(Ereplace(Ereplace('132,21.32', ',','*'),'.',','),'*','.') gives you 132.21,32

[gpbarsky]

Thanks a lot to everybody.

I used the last given solution, which I consider the easiest. But, I had to convert in the following order:
1) Replace the decimal "." for a "-".
2) Replace all "," for the ".".
3) Replace "-" for the ",".

EREPLACE(EREPLACE(EREPLACE(num,".","-"),",","."),"-",",")

Again, I love this forum.

P.D.: does it exist an user guide for server jobs and sequencers ?

[narasimha]

Yes, there are Online Manuals/User Guides for server jobs and sequencers, it comes along when you install the software.
The logic is not in any guides, just gave it a thought!
Glad it helped :D
If you have resolved it, mark it as resolved (Ofcourse with your rating!)

[ArndW]

Thats a tricky one.
A little Math can also help here.

Code: Select all

Ereplace(Ereplace(Ereplace('132,21.32', ',','*'),'.',','),'*','.') gives you 132.21,32

If you really want to go the text route, use

Code: Select all

CONVERT('123,456.78',',.','.,')

, is it simpler and more efficient. I still think that the number should be formatted as a number, but as you can see, there are many methods that lead to the same result.

[narasimha]

Arndw,

I tried using your piece of code

Code: Select all

CONVERT('123,456.78',',.','.,')

I did not get the desired results. Am I missing something? Please advice.

[ArndW]

Oops, I got the order of the parameters wrong. Sorry.

Code: Select all

CONVERT(',.','.,','123,456.78',)

[narasimha]

Thanks for the clarification. Always nice to know different available methods.

[ray.wurlod]

P.D.: does it exist an user guide for server jobs and sequencers ?

Server Job Developer's Guide
Core Developer's Guide
Both manuals are in the Docs folder with your client software.