Regex_Replace formula

[RajatRehria]

Hi Guys, i want to remove everything in a string after first pipe ( | ) character (including pipe) using Regex_Replace formula, please help. Thanks.

Input: ABC LTD CRM BA YUNN FC XYZC|RUN TIME : 01/15/2023 02:57|12345678

Output: ABC LTD CRM BA YUNN FC XYZC

[DataNath · Accepted solution]

Hey @RajatRehria, there's no need for RegEx here really - can do this quite easily with regular string functions!

Left([Input],FindString([Input], '|'))

Just replace the two [Input] references with your actual field.

[Felipe_Ribeir0 · Accepted solution]

Hi @RajatRehria 

You can use this formula:

REGEX_REPLACE([INPUT], '(.*?)(\|.*)', '$1')

[RajatRehria]

Many thanks to @DataNath and @Felipe_Ribeir0  for the solutions.

[PhilipMannering]

I like @DataNath solution. The simpler regex would be,

REGEX_Replace([Test], '\|.*', '')

[Meggan]

what tweak would be needed to pull only the numbers to the right of a field? 
BPGM48B3 210 output 210
MECL20X7 1 output 1