Remove text and add

[yeruvab]

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

[kamal03]

Hi @yeruvab 

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]))

.

[binu_acs]

@yeruvab One way of doing this

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

[yeruvab]

Thank you for your prompt reply, it worked :)

[yeruvab]

This worked like magic!! thank you so much :)

[yeruvab]

Thanks!

[yeruvab]

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