Get value between last en second last delimiter from string

(0) Share

Report

Posted on by RobMolenaar

Hi all,

I can't get a value from a string.

I want the value between the last and second last delimiter.
String example 1:

Quality management system; Processes per department; Academy; External training for contract partners

I want to have: "Academy"

String example 2:

Quality management system;Processes per department;Business Commercial;Evaluating collaboration with contracted business customers;Preparing evaluation interview

I want to have: "Evaluating collaboration with contracted business customers"

What is the best way to achieve this?

Best regards,

Rob

All responses (5)

Answers (1)

RobMolenaar 97 on at

Like (0)

Report

Re: Get value between last en second last delimiter from string

Thanks! This solved my problem.
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (2)

Report
Re: Get value between last en second last delimiter from string

Hi @RobMolenaar

To get the second last item irrespective of items length in the string, pls use the below expression in the 'Compose 3' action:
first(take(skip(reverse(split(outputs('Compose_2'),';')),1),1))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks
RobMolenaar 97 on at

Like (0)

Report

Re: Get value between last en second last delimiter from string

Hi Sudeep,

Thanks for the help.

I always want the second last item.

When I use the compose and split it is working but when I use the expression in the Select action it gives an error when executing the flow.

Part of the flow:

Error:
SudeepGhatakNZ 14,376 Most Valuable Professional on at

Like (0)

Report

Re: Get value between last en second last delimiter from string

@RobMolenaar ,

Is it always the second last item you want to retrieve?

The expression split(YourInput,';') will return you an array with 4 items.

You can retrieve the second last item using split(YourInput,';')[2]

The above setup will return the value 'C'
SudeepG 24 on at

Like (0)

Report

Re: Get value between last en second last delimiter from string

n