Answered

Extract text after last instance of a hyphen

(0) Share

Report

Posted on by MishkaGrizzly

Hi,

I have data that can be any combo such as this. Sometimes its one ref number and then the description, sometimes its two ref numbers and then the description.

00200844-Digital
00232654-0897977-Electrical
00565678-08083443-Specialist

I am trying to extract the text after the last hyphen, so the end result would be

Digital
Electrical

Specialist

I tried to use split but it doesn't seem to be working where there is two hyphens present.

Thank you in advance for any help

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Power Robo 19 on at

Like (0)

Report
Copy link

Link copied!

Hi,
You can extract the text after the last hyphen by using:
last(split(<yourString>, '-'))

This splits the text at every hyphen and returns the final segment.

In your case, If your strings look like:

00200844-Digital
00232654-0897977-Electrical
00565678-08083443-Specialist

last(split(items('Apply_to_each')?['YourColumnName'], '-'))

then you will ge the expected output as:
Digital
Electrical
Specialist

Cheers!

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,081 on at

Like (1)

Report
Copy link

Link copied!

For each string use:

last(split(variables('your_string'),'-'))

2 people found this reply helpful.

Was this reply helpful? Yes No
Power Platform 1919 2,221 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

HI ,
Adding to VictorIvanidze response,

Here is the sample flow,

result of executed run :

Was this reply helpful? Yes No
MishkaGrizzly 55 on at

Like (0)

Report
Copy link

Link copied!

Thank you both, worked like a charm!

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Glad to help, МишкаГризли!

Was this reply helpful? Yes No