Remove unwanted character from Column name in data table

Help Studio
, ,
1

Hi All,

Kindly help to remove extra spaces and characters from below attached string (highlighted in red circle).
image

Any help would be appreciated, Thanks

2

@shekharhimanshu627
Assign inputString = “Entity Type [Entity Name] :diamonds:”
Assign trimmedString = inputString.Trim()
Assign cleanedString = trimmedString.Replace(“:diamonds:”, “”)
Message Box to display cleanedString

3

Use the below regex expression in assign activity. @shekharhimanshu627


System.Text.RegularExpressions.Regex.Replace(InputString,"[^a-zA-Z0-9\]\[\s]","").Trim

Regards