Excel hidden formatting symbol

[VanjaV]

Hi,

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.

Any suggestions?

Thx and kind regards,
Vanja

[Anil_G (Anil Gorthi)]

@VanjaV

You can use regular expressions before pasting the data

System.Text.RegularExpressions.Regex.Replace(str,"[^A-Za-z0-9/]*"," ")

Cheers

[VanjaV]

@Anil_G

System.Text.RegularExpressions.Regex.Replace(str,“[^A-Za-z0-9/]*”," ")

Hi @Anil_G

it does:

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

[Anil_G (Anil Gorthi)]

@VanjaV

Please try using plus(+) instead of star(*)

And retain space only

Cheers

[VanjaV]

Hi @Anil_G this is great!

But now it cuts “(” and “)” from the whole content:

[Anil_G (Anil Gorthi)]

@VanjaV

If you need brackets then the expression would be like this

"[^A-Za-z0-9/()]+"

Basically what I am doing here is giving the expression to not consider the values I specified and replace any other value with space

Cheers

[vishal.kp (vishal)]

Hi @VanjaV ,

use the curved brackets in your condition:

[^A-Za-z0-9()]+

Regards,

[VanjaV]

@Anil_G

[^A-Za-z0-9/()]+

Yes, this is it:

Thank you very much!
Vanja