Regex_Replace formula

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

Regex

Accepted answers

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.

You can use this formula:

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

regex111.yxmd

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.

You can use this formula:

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

regex111.yxmd

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

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

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

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