Remove some parts of a string

Hello, I want to remove some parts of a string.

My string example is

image

And I want to remove all the “!” signs and have just only 1 left to build a table out of it and use the ! sign as separator.

Is there any simple solution to this?

Kind regards,
TPA

Hey!

Try like this

InputString.Replace("!"," ")

In generate data table give the separator as Space

Regards,
NaNi

Hey

You can use this

StrVar. Replace(“!”, “”)

Thanks

Hi @Paul_Andrei_Turcu

Try this

NewString = System.Text.RegularExpressions.Regex.Replace(YourString, "!{2,}", "!")
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.