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:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

CU27111039-0 2 on at

Like (0)

Report

Extract text after last instance of a hyphen

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 12,962 on at

Like (1)

Report

Extract text after last instance of a hyphen

For each string use:

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

2 people found this reply helpful.

Was this reply helpful? Yes No
Power Platform 1919 1,519 on at

Like (1)

Report

Extract text after last instance of a hyphen

HI ,
Adding to VictorIvanidze response,

Here is the sample flow,

result of executed run :

Was this reply helpful? Yes No
MishkaGrizzly 42 on at

Like (0)

Report

Extract text after last instance of a hyphen

Thank you both, worked like a charm!

Was this reply helpful? Yes No
VictorIvanidze 12,962 on at

Like (0)

Report

Extract text after last instance of a hyphen

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

Was this reply helpful? Yes No