Table row split into many columns

Beginners
1

HI
Is there an op that will take a long row in a table (200k of values) and split it up into multiple columns?
To automate making x columns?

thanks for your help
Joe

2

The Convert DAT does this. You can specify the characters at which a new column should be created.
Example attached

convert_table_example.tox (382 Bytes)

3

Thanks but I have hundreds of thousands of long number that need to be split into columns.
data eg
0.22443773
0.45221865
0.23786375
0.03549609
For example Id like to split this every 2000th row into a new column. I dont think I can do what your saying with this much data.

Am I missing something ?

Ultimately to make a series of data to chop to tops. Large data sets seem to grind TD to a halt so Im converting the data into TOPs to re-import as tifs which I hope can be handled quickly.

4

Ah sorry I answered too quickly. These floats are perfect for TOPs indeed. But I would skip the CHOP step.
In your case I would choose Python to read the values into a NumPy Array, and then write that directly to a TOP (use the copyNumpyArray method of the Script TOP). You can already store a million floats into a small 500x500 RGBA texture.

1 Like
5

Also @semiconductor see the Operator Snippets for the Script TOP in latest TD release to see some examples how to use NumPy arrays to write a TOP.