how to escape characters like ? or ’ into a read range activity?
in a foreach activity i will extract colomm information to put them into a web formulaire and It seem that I have error in my datatable with special characters…
how to escape characters like ? or ’ into a read range activity?
in a foreach activity i will extract colomm information to put them into a web formulaire and It seem that I have error in my datatable with special characters…
Replace special characters with nothing like below -
yourString.Replace("?","").Replace("'","")
You can add more replaces if any.
Regards,
Karthik Byggari
Hi
Welcome back to uipath community
if we have any other escape characters apart from ? ’ a single regex expression can replace all of them
–so inside the FOR EACH ROW loop with datatable variable as input
use a assign activity like this
row(“yourcolumnname”) = System.Text.RegularExpressions.Regex.Replace(row(“yourcolumnname”).ToString,“[\W]+”,“”).ToString
Cheers @lionel31
Thanks i will try this regex
with this output :
roww(“Questionnaires Chemin”).ToString
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.