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)

Sort by

SudeepG 24 on at

Like
a
(0)

Report
Copy link

Link copied!

n

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

Like
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

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

Manish Solanki 15,169 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

Thanks! This solved my problem.

Was this reply helpful? Yes No