Convert Dot into Comma

[AsitabhaDeb]

Hi,

I have one text data item "9.83", now I would like to write it in SAP as "9,83". I have already created write stage.

How I would convert 9 dot 83 to 9 comma 83.

Please help me.

BR/Asitabha

------------------------------
Asitabha Deb
------------------------------

[hossein.azimi]

Hi Asitabha,

I suggest converting the number as a text and replace "." to ",".

Input number = Text

Cal 1 =  Left([Input Number], Len([Input Number])-2) &"."&Right([Input Number], 2)

Data = Text

Cal 2 = Replace([Data], ".", [Out number])

Out number = Text

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------

[NicholasZejdlik]

On your input for the write stage, use the expression Replace([Number], ".", ","). It shouldn't matter if the data item is being stored as a number or text; if it's a number, it will be implicitly converted to text when it's passed into the Replace() function.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

[AndrzejFidos]

Hi,

you can do it like this. Wherever it finds "," will repalce it with "." No matter the Length or the value. In case it is just one Data Item use : Input Data Item, Output Data Item in Cal Stage (Not Multi Calc). 

------------------------------
Andrzej Fidos
------------------------------