How to discard the last few words from concatenated string

[Rohan2020]

I looking for solution to discard the last three words from concatenated string. The string length is dynamic and gets generated based on excel file input. 

For Eg.

abc|def|acd|cf78c|bn12mn

Exclude -acd|cf78c|bn12mn from above string

[mbarone]

Are the words always going to be separated by pipes so that essentially you need to remove everything from the third-to-last-pipe on?

[messi007]

@Rohan2020,

please see below:

Attached the workflow,

Regards,

[MarqueeCrew]

@Rohan2020,

If you use a Text to Columns and set the delimiter to PIPE, you can set the # of output columns to 2 and discard the remaining contents.  Alternatively..

REGEX_Replace([Field1], "(.+)\|.+\|.+\|.+", '$1')

Cheers,

Mark

[Rohan2020]

Yes the string is always separated with pipe | and it should exclude the last three words and return remining string.

Exclude -acd|cf78c|bn12mn

[messi007]

@Rohan2020 

Have you tried my solution or @MarqueeCrew solution's?

If this solves your issue please mark the answer as correct, it will help others!

Regards,