topic RE: Convert Dot into Comma in Product Forum

Convert Dot into Comma

AsitabhaDeb — Sun, 20 Dec 2020 06:29:00 GMT

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
------------------------------

RE: Convert Dot into Comma

hossein.azimi — Sun, 20 Dec 2020 23:10:00 GMT

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
------------------------------

RE: Convert Dot into Comma

NicholasZejdlik — Mon, 21 Dec 2020 14:23:00 GMT

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
------------------------------

RE: Convert Dot into Comma

AndrzejFidos — Mon, 21 Dec 2020 18:49:00 GMT

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
------------------------------