Get value between last en second last delimiter from string

(0) Share

Report

Posted on by RobMolenaar

112

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

SudeepG 24 on at

Like (0)

Report

n

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@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'

Was this reply helpful? Yes No
RobMolenaar 112 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (2)

Report
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

Was this reply helpful? Yes No
RobMolenaar 112 on at

Like (0)

Report

Thanks! This solved my problem.

Was this reply helpful? Yes No