Removing string with different delimiters and length

[ViTLe]

Hi there,

I need help with how to extract a string from another string with very specific situations. I have tried using Cell Splitter, Regex Split, String Manipulation but can’t get the results I need.

Here is the table which has different label naming conventions because people aren’t consistent:

Sample.xlsx (9.7 KB)

If anyone can please help, I would greatly appreciate it.

[HansS]

Hi @ViTLe

If I use the Cell Splitter node with only a dash as a delimiter, it gives the expected output. Did you try the dash as delimiter, so without white spaces; and leave the option Remove leading and trailing white space chars (trim) checked?
gr. Hans

[piotr_domagala]

You can try String manipulation node with function
regexReplace($nameOfColumn$,"^[^\\w+([^\\w]+|[_]+)","").
It will remove all alphanumeric characters from the beggining of string to first non alphanumeric characters and leave desired part of string.

[gonhaddock]

Hi @ViTLe
A possible solution with two nodes:

• ‘String Manipulation’ node:
  replace($column1$, " ", "")

• ‘Cell Splitter’ node:
  Delimiter “-” (just this)

RESULTS:

BR

[ViTLe]

@gonhaddock @piotr_domagala @HansS Thank you so much, all your solutions worked and it’s so fantastic that a solution can have so many different ways.

[ViTLe]

@HansS You are a legend HanS. I think I overcomplicated my use of the Cell Splitter when it was a simple - setting, which is why I couldn’t get it to work.