Tab seperating characters in a string

KNIME Analytics Platform
1

Hi everyone,

I have been trying to figure out a way to add a tab delimiter in a string. I want my string column to remain as a single column. 

Ex: 100111 --> 1    0    0    1    1    1

 

I have been playing with the string replacer node, but have not been able to get it to work. It will literally insert "\t" instead of an actual tab.

 

-▲

2

hi there
please be a bit more specific regarding input and output.
And do you really need a tab or can it be replaced by another separator as well such as / or ; or , ?

3

Yes, I need tab separated values.

My input column is strings of 0s and 1s with no spaces, and I would like my output to be the same string just with each character separated by a tab. 

So my example is literally what I would like done:  "100111"  > "1    0    0    1    1    1"

 

Thanks

-▲

4

ok.. so I tried the following and it looks promissing..
use two string manipulation nodes and insert in the first:
replace($bits$,"0", "0  \t")

and then use the new column (called bits2 in the example) and put in the second

replace($bits2$,"1", "1 \t")

hope that helps..

5

Thanks adaptagis, this works perfectly for me!

 

To anyone else wanting to use this, just make sure you remove the spaces in the code above.

 

Node 1: "String Manipulation"

replace($bits$,"0", "0\t")

Node 2: "String Manipulation"

replace($bits2$,"1", "1\t")

 

-▲