I have an issue with my automation, I’m trying to remove the special characters from a table inside a link and place them into an excel file. The thing is that I get an error after scraping some data, and it is from the extension of a phone number, for example: “=40” instead of “+40”.
I tried the following syntax: * System.Text.RegularExpresions.Regex.Replace(Column.ToString, “[^a-z A-Z 0-9 / . 0 @ + -]”, “”) * and i think it is working up to a point, from that point on I get the error that: “the range doesn’t exist” inside a write range activity, and that is because at that point, in the table, there is that “=” in the pn.
I know that a have to use the assign activity to assign the above syntax, but I can’t figure out where to integrate it.
If you have any insight please share some:)
Have a good day and happy animations