Trim Text before second delimiter

[PBI_newuser]

Hi, 

I have a list of products as below. I wish to truncate the "(X-YZ)-" and "(AB-D)-" from the name.

How can I do it?

Product (Before)

(X-YZ)-FRIDGE

WASHING MACHINE

(AB-D)-DRYER

IRON

Product (After)

FRIDGE

WASHING MACHINE

DRYER

IRON

[Anonymous]

I don't think it's the most efficient way but you could do this using power query. 

Add conditional column, Merge, then split by a delimiter. 

[tex628 · Accepted solution]

Try extracting text after rightmost delimiter:







Br,
J

[Anonymous]

Hi,

What you can try in PowerQuery is use: Text.AfterDelimiter(Product, "-", {0, RelativePosition.FromEnd})