In XLS there is input like “EPVD 1128/2022”:
which in Word shows hidden formating symbols like this:
I need to replace the two hidden formatting symbols
but do not now what character they are.
Thx and kind regards,
You can use regular expressions before pasting the data
If I use System.Text.RegularExpressions.Regex.Replace(vcString,“[^A-Za-z0-9/]*”,“”), then it does:
But I need to keep the space:
Kind regards, Vanja
Please try using plus(+) instead of star(*)
And retain space only
Hi @Anil_G this is great!
But now it cuts “(” and “)” from the whole content:
If you need brackets then the expression would be like this
Basically what I am doing here is giving the expression to not consider the values I specified and replace any other value with space
Hi @VanjaV ,
use the curved brackets in your condition:
Yes, this is it:
Thank you very much!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.