I have a Text File in which I am gleaning Currency Amounts from the Text. I pull this data into a Data Table then parse the Text into Variables where ultimately they will be passed to a SQL Table for storage.
The problem I am having is that the Text Currency has a Dollar symbol in front of the number and no matter what I have tried, I cannot strip the Dollar symbol from the stored variable. This interferes with my Query to insert the values as a Number. Every attempt to convert the Data Table Data to a Real Number, Float, Int, Int32, Double has failed.
Example Error Message:
I want to do this without having to shell the data out to a CSV / Excel File where I can easily convert this to number and read it back in. I want to accomplish this task strictly within the UiPath Environment.
Here is some examples of what I have tried that did not work:
In an Assign Activity:
Prod_Rate_Mth = (Convert.ToDouble(row(5)))
, Also tried .ToInt16
, .ToInt32
Tried Stripping the Dollar Symbol: System.Text.RegularExpressions.Regex.Replace(input_Text.ToString, "$", "").ToString.Trim()
I’m at a total loss as to why this cannot be done inside UiPath. Going down the road to farming the coding of the Currency amounts I need changed to a Double Type Number in and external process.
Any Help is appreciated!
Thanks!