Hi A T - thank you for the kind words, happy that it helps. Indeed the String Manipulation Node is an awesome one, very useful for a lot of things (from file paths to splitting names etc) 😀 I appreciate that you took the time to leave a comment 👌
Thank you for the comment. I am not sure I understand it though. If you want to split a text / string there are several options: the Cell Splitter Node, the Regex Split Node (if you know regular expressions) or you can do it within the String Manipulation Node.
Hi , thanks for your videos any idea how to use more than one expression in a string manipulation node ? i want to use 2 expressions , first i am removing a char from a specific column and next i need to add a string to that first output from the first expression can i do that withing a single node? or do i need to use 2 node for each expression ?
Basically you can nest functions within the String Manipulation Node just like you can in Excel. However, this comes at the price of "workflow clarity". If you do a lot of workflows that others need to understand or that you yourself only open once in a while, I would probably go down the "more nodes, easier to understand route". I have created an example workflow for you showing both approaches: hub.knime.com/-/spaces/-/latest/~NlsXM-yUlQot03CH/ let me know, if this helps.
i have a column one column and i want to split but the column have a serial number like 1sgts2ayada 2shjs3wd 3mnsad … till 1000xxxx and i want to output like this 1 sgts2ayada 2 shjs3wd 3 mnsad … 1000 xxxx
Thank you for the comment. You basically want to do a regex split. Regex (short for regular expressions) is kind of a meta language that let's you deal with text (as in your example). The pattern I could see from your comment is that you want to separate AFTER the first digits (but not for any following digits). So I used a Regex Split Node with the following Regex (code): ^(\d+)(\D.*)$ What this basically does it captures the two parts of your text (String). The first part is a sequency of digits, then it splits and puts the rest (no matter if digits, letters or other characters in the second 'split column') Now, if you don't want to recreate this based on my response, I have uploaded an example workflow for you to my public space on the KNIME Hub: hub.knime.com/-/spaces/-/~dnGssJZnPQOoCa-5/current-state/ If you find my response useful, I would like to invite you to my free weekly newsletter, where I share tutorials like this, vouchers and other goodies with the 'tribe': procurementzen.com/newsletter
THANK YOU SO MUCH FOR EXPLAINING THIS SO BEAUTIFULLY !
Hi A T - thank you for the kind words, happy that it helps. Indeed the String Manipulation Node is an awesome one, very useful for a lot of things (from file paths to splitting names etc) 😀
I appreciate that you took the time to leave a comment 👌
You can join more than one by adding additional arguments separated by a comma
Separates the text from the number in the same column. Number in various parts of the text.
Thank you for the comment. I am not sure I understand it though. If you want to split a text / string there are several options: the Cell Splitter Node, the Regex Split Node (if you know regular expressions) or you can do it within the String Manipulation Node.
Hi , thanks for your videos
any idea how to use more than one expression in a string manipulation node ?
i want to use 2 expressions , first i am removing a char from a specific column and next i need to add a string to that first output from the first expression
can i do that withing a single node? or do i need to use 2 node for each expression ?
Basically you can nest functions within the String Manipulation Node just like you can in Excel. However, this comes at the price of "workflow clarity".
If you do a lot of workflows that others need to understand or that you yourself only open once in a while, I would probably go down the "more nodes, easier to understand route".
I have created an example workflow for you showing both approaches: hub.knime.com/-/spaces/-/latest/~NlsXM-yUlQot03CH/
let me know, if this helps.
i have a column one column and i want to split but the column have a serial number like
1sgts2ayada
2shjs3wd
3mnsad
… till 1000xxxx
and i want to output like this
1 sgts2ayada
2 shjs3wd
3 mnsad
…
1000 xxxx
Thank you for the comment. You basically want to do a regex split. Regex (short for regular expressions) is kind of a meta language that let's you deal with text (as in your example).
The pattern I could see from your comment is that you want to separate AFTER the first digits (but not for any following digits).
So I used a Regex Split Node with the following Regex (code): ^(\d+)(\D.*)$
What this basically does it captures the two parts of your text (String). The first part is a sequency of digits, then it splits and puts the rest (no matter if digits, letters or other characters in the second 'split column')
Now, if you don't want to recreate this based on my response, I have uploaded an example workflow for you to my public space on the KNIME Hub: hub.knime.com/-/spaces/-/~dnGssJZnPQOoCa-5/current-state/
If you find my response useful, I would like to invite you to my free weekly newsletter, where I share tutorials like this, vouchers and other goodies with the 'tribe': procurementzen.com/newsletter