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.
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 , ?
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"
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..
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"
Node 2: "String Manipulation"