Take a substring and convert to number and Print in Excel

[Tanzill_Ahsan]

Here, I want to take a substring from the column rate except for the percentage sign, e.g 1.05

I want it also in number format. Whenever I am trying to print the result in debug mode using writeline activity. This is the output I am getting.

Can anyone show me a pseudocode or a exemplary workflow design for this?

[GBK]

@Tanzill_Ahsan

substring from the column rate except for the percentage sign

@Tanzill_Ahsan - you can try with a string replace ```
expectedString= actualString.replace(“$”, “”);

[Divyanshu_Divyanshu]

@Tanzill_Ahsan

Use the code shown in the screenshot
you will get your desired output