Convert text format

[CamiCat]

Hello friends,

how to convert a text from this format 3456.89 to 3.456,89?
Thank you so much,
Cami

 

[sivagelli]

Hello friends,

how to convert a text from this format 3456.89 to 3.456,89?
Thank you so much,
Cami

Where so you have the text ? Data Item or Excel?

 

[CamiCat]

Hello @sivagelli,

it's a text data item.Thank you.
Cami

 

[RavitejaKiran]

Hello friends,

how to convert a text from this format 3456.89 to 3.456,89?
Thank you so much,
Cami

So you want to replace a "." with "," and a ". " should be placed after the first number?

If not please explain in detail.

 

[CamiCat]

Thank you @RavitejaKiran,

I want to replace a "." with "," and use "." for indicating thousands.
How can I perform this task'
Thank you so much,
Cami

 

[sivagelli]

Hello @sivagelli,

it's a text data item.Thank you.
Cami

If it is a data item, you can only achieve this using Code stage.

Add a code stage with -

• Input:
  • inNum of text type
• Output:
  • outNum of text type
• Code Tab

  • outNum = string.Format(System.Globalization.CultureInfo.GetCultureInfo("de"),"{0:0,000.000}",double.Parse(inNum));

The number format changes from US to other countries. Number 1243.45 in US is represented as 1243,45 in Germany, Italy and other countries. Here for conversion, i changed the number format to Germany. CultureInfo.GetCultureInfo("de") is for Germany. Thousands are separated by dot and decimal are with comma. Swedan uses space.

On execution, outNum will have the number of required format.

3456.89 will be converted to 3.456,89.

Post back how it goes!

 

[CamiCat]

Thank you so much @sivagelli.Worked very well.
How to convert a text 3456,89 to a number in the format 3456,89?
Thank you so much

 

[sivagelli]

How to convert a text 3456,89 to a number in the format 3456,89?

Both formats look same

 

[CamiCat]

Hello @sivagelli,

I need to convert drom text to number and it deletes the ",".
How to maintain the same format?
Thank you,
cami

 

[sivagelli]

Hello @sivagelli,

I need to convert drom text to number and it deletes the ",".
How to maintain the same format?
Thank you,
cami

Are you looking for output to be of number type? The above code i shared returns output of text type.

 

[CamiCat]

Exactly @sivagelli,

can you please help me'
Thank you so much,
Cami

 

[sivagelli]

I am not sure, but it is that you will lose the formatting on conversion.

 

[CamiCat]

Is there a way to do that?
Thank you so much,
Cami

 

[Jas]

I think I have the same issue as CamiCat.

When trying to convert text "1234,56" to number using ToNumber(), I get 123456. So the result is a hundred times larger than it should be because the decimal separator is missing. Any ideas on how to fix this?