Remove all characters before the last match

[bermq]

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?

[HansS]

Hi @bermq

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

gr. Hans

[bermq]

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

[AnotherFraudUser]

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…

[bermq]

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.

[AnotherFraudUser]

Hi @bermq,

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

l