Remove all characters before the last match

Hi!

I have this text:

D:\KNIME_0347_Bitterfeld\DART\2016\034716T\W_ACCDET.sap

I should delete all the characters before “W_”

I’m trying with the Regex split using this expression:

^[^ ]* (.*)$

but the output is:

“Bitterfeld\DART\2016\034716TXW_ACCDET.sap”

And it should be:

“ACCDET.sap”

aNY SUGGESTION?

Hi @bermq

Use the String Manipulation node with:
substr($column1$, indexOf($column1$, "W_" ) + 2 ,99 )

gr. Hans

3 Likes

Many thanks Hans!!! It works perfectly
Thank you so much
Roberto

1 Like

oh @bermq you created an additional topic for that…
Please close the previous topic before creating a new one with the same question… so people do not answer questions twice…

1 Like

Dear AnotherFraudUser,

Sorry, since I reformulated my question I believed the topic should be changes too.

But I see your point, and I in the future I won’t open a new topic.

1 Like

Hi @bermq,

no problem - you can open a new topic for that :+1: then just comment on the old topic that you moved the issue to a new case :slight_smile:

l

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.