Remove text and add

I have question on how to achieve column name 'ABC' has a value Butterflies | Props,

add 'PRP: ' in front of text AND Remove anything before the | , example output like PRP: Props

Developer

Output

Parse

Accepted answers

There are multiple ways to do this, one of them is to use a formula tool to substring the string.

Try the below formula :

'PRP:' + Substring([ABC], FindString([ABC],'|')+1,Length([ABC]))

@yeruvab One way of doing this

Trim(REGEX_Replace([Abc], '.*\|(.*)', 'PRP:$1'))

Thank you for your prompt reply, it worked

This worked like magic!! thank you so much

Thanks!

The data source is excel file and its not taking the empty cell as null.