Removing prefix and suffix

[bbaisil]

Hi,

I need to remove the prefix(') and suffix(') from the program display here. I just need the number.

For example '4747' to 4747.

How can I do that ?

[gabrielvilella]

Hi @bbaisil, you can use a Data Cleansing tool and remove punctuation or use a Formula to replace that character with nothing.

[Qiu]

@bbaisil 
Depends on the context of your " program display", better to use Regex.

[atcodedog05]

Hi @bbaisil 

Another method is by using Trim function which removes characters from the beginning and ending.

Trim([program_display],"'")

Workflow:

Hope this helps : )