I need your help with some string manipulation. I am trying to extract some specific value from a text. My column goes like this
;|X2C1231890000|Shape not found||||A1010.FindShape||2
I want to extract the A1010 part only. There are 5 characters in A1010 but sometimes there are 6 or 7 max.
Also anything after that ‘.’ can have multiple characters. This is just an example.
I tried using string manipulation node but no luck with that. Maybe doing something wrong. Can anyone help me as to I can solve this problem?
Assuming the number of |-characters is always the same, the String Replacer node with an appropriate regular expression may do the trick:
edit: in case you want to copy-paste the regex:
Nice. I might try to replace my 4 string manipulation nodes with one using this.
Currently I have been using replace($Group 1$,"/","_")
Then change the “/” with “:” or “” for the next node.
This is so I can generate a file name that can be created and saves.
Certain characters do not.
Sorry to thread hi-jack.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.