- Code: Select all
substitute($V," ",\t)
seems right, but it appends a literal "\t" in every blankspace when I do it. Put it in quotes and the same thing happens.
...And how should I have found the answer without asking online?
Many thanks.
|
|
||||
|
|
|
|
|
|
|
|||||||||
substitute($V," ",\t) substitute($V, " ", " ")substitute("$V", " ", ftoc(9))Or you can use 2 Convert DATs, the first converting To Table using " " for the Split Cells at parameter[...]
rhaines wrote:(Answering my own question here:)
There is no change from input to output because the OSCin DAT is *already* a table, and the convert DAT apparently doesn't touch data within a table when "To Table" is selected. It seems like this behavior could safely and usefully be changed since the goal is to make table data even more table-y ("table-acious"? "tabuloid"? "tablish"?)
The workaround is to convert(DAT) "To Text", then convert(DAT) "To Table" with Split Cells At [space]. Note that using " ", including the quotes causes extra blank cells to be generated. Just a single space is needed in the field, which will look empty.
Users browsing this forum: No registered users and 0 guests