Removing Text From Input

altJR

Good Day

Please can someone advise how to accomplish the following :

I'm trying to remove all text from beginning of line to character after the pipe … examples below :

"first | abc" should show as "abc"

"second | def" should show as "def"

"third | ghi" should show as "ghi"

The location of the pipe (|) varies on each line.

Note that the quotes are not included in the input … it's shown here just to highlight input and output.

Thanks in advance

philipmannering

You can use a Split to Columns tool to divide that field into two fields.Then use a data cleanse to get rid of the spaces.

Or you can use a formula tool and getword([Field],2)