Insert decimal two places to the left in a string

[Josh_James (Josh)]

Hello,

I can’t seem to find an answer to this question. I am trying to insert a decimal in a string that has whole numbers. Our API request only returns numbers without decimals. I am trying to paste these numbers into a sheet, but with the decimal. Here’s an example.

If the string is “19432”, I need it to look like “194.32”

“4” is actually “.04”, “10” is “.10”, etc…

Thanks!

[pravallikapaluri]

Hi @Josh_James

Assign activity: Set inputString = “19432” // Replace with your input string

Assign activity: Set outputString = String.Empty

If activity: Condition inputString.Length = 1
Assign activity: Set outputString = “0” + inputString.Substring(0, 1) + “.” + inputString.Substring(1)
Else
Assign activity: Set outputString = inputString.Substring(0, inputString.Length - 2) + “.” + inputString.Substring(inputString.Length - 2)

Write Line activity: Output outputString // Output the result to the Output panel (optional)

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @Josh_James

Try this

(Convert.ToDouble(Number) / 100.0).ToString("0.00")

I hope it helps!!

[postwick (Paul Ostwick)]

(CDbl(yourString) / 100).ToString(“F2”)

Here is a good list of standard format strings that can be used in .ToString

Standard numeric format strings

[Parvathy (PS Parvathy)]

Hi @Josh_James

Use the below syntax in Assign Acitivty:

originalNumberString="19432"        (Datatype: String)
decimalNumber=Decimal.Parse(originalNumberString) / 100       (Datatype: Double)
formattedNumber= decimalNumber.ToString(".00")                        (Datatype: String)

Print ofrmattedNumber variable in Message Box.

Shared the workflow too
Sequence4.xaml (6.6 KB)

Hope it helps!

[vrdabberu (Varunraj Dabberu)]

Hi @Josh_James

(Convert.ToDouble(InputVariable) / 100.0).ToString("0.00")

Hope it works!!

[Josh_James (Josh)]

Hi @lrtetala , thank you for this!! This works perfectly! I also appreciate everyone else’s responses, love this community!