String manipulations

[Ramakant_Patil]

Hello,

In a column I have data like

M:\bep\BU3\cat5\Features\BU3-Feates\2-PDAC\Airmodules\A__BLOWELEMENTS\BLDC_BLOWEOUNT\SF_BLDC_BLOWER-MOUNT_V7

I just want to extract data “A__BLOWELEMENTS”.

It may be start with B__ or C__ or D__. Wanted to extract data from between backslash.

I tried with this " regexExtract($Location$,“(?<=\).?__.?(?=\))”) but it will not working

[HansS]

Hi @Ramakant_Patil

Maybe not the most elegant solution, but did you try the Cell Splitter node?

Cell Splitter

gr. Hans

[gonhaddock]

Hello @Ramakant_Patil

It’s hard to guess with a single case as it could not represent the whole data set…

You can test the following code within a ‘String Manipulation’ node. It works for the given example:

regexReplace($Location$, ".+[\\\\]+?([ABCD][_].+?)\\\\.+", "$1")

BR

[Ramakant_Patil]

hello, thanks for the reply.

regexReplace($Location$, “.+[\\]+?([ABCD][_].+?)\\.+”, “$1”) — This solution works partially. Only did for the A__ , B__, C__, D__ and not for others.

I modified the formula with regexReplace($Location$, “.+[\\]+?([ABCDEFG][_].+?)\\.+”, “$1”)----Now it works perfectlly.

Thanks for the solution.