EDIT - dynamically change a cell value in a table DAT

Beginners
1

the title was worded weirdly - 'scuse me…basically I want to be able to change a single cells (or at times all of them) value - that table will eventually get pumped into a ramp CHOP, but it doesnt really matter.

Ive been messing around with all sorts of DATs, merge, select, and so on, but I cant seem to crack this seemingly simple nut. any help would be great…

2

if you just want to change a single cell, will the Substitute DAT work? you can set the cell you want to change in the Scope tab. in the Substitute tab, put * in From and put your new value (can be an expression if you use the expand option) in To.

hope this helps.

Selina

3

Thanks Selina, I was just missing a few minor things. Now where I am stuck, is that the value doesnt get re-inserted to the rampDAT (though I have pointed the rampDAT to the correct table with the new value)

here’s a simplified .toe file to explain. i know i am just stuck on something minor here - the documentation seems a little sparse on these topics…
changeTblCell.toe (5.71 KB)

4

in your Substitute DAT, put the expression (including backticks)
chop("/project1/null5/v1")
in your To field. that should fix it. alternatively, you could skip the backticks, and add an evaluate dat outputting expressions after. hope this helps.

Selina

5

whoop! that did the trick. I guess without the backticks you meant use a execute DAT - listen, can you point me to a place that documents how to do what you just showed me how to do? as well as write the expression for the execute DAT? when I click edit on the execute DAT, nothing happens - I suppose I need to tell touch what editor to use? but where…

(i swear when i get my head wrapped around this software Ill ask less questions…eventually :wink:

thanks!
matthew

6

glad that worked for you.

I do mean the Evaluate DAT, not the Execute DATs. Evaluate will modify input data by expanding strings or evaluating expressions. so if an incoming cell have
chop(“/project1/null5/v1”)
it’ll evaluate that expression (if the output type is expression) to whatever the value is.

if you want to use an CHOP Execute DAT to update table values, that’s scripting, which I think isn’t as streamlined for what you are trying to do. to update via a script, you will use a CHOP Execute DAT to monitor your incoming chop for value changes, and on that, set the table value for the cell you want to change via a table command. the relevant wiki articles would be:

[url]http://www.derivative.ca/wiki/index.php?title=CHOP_Execute_DAT[/url]
[url]http://www.derivative.ca/wiki/index.php?title=Table[/url]

and here’s the docs about backquotes.
[url]http://www.derivative.ca/wiki/index.php?title=Expression[/url]

asking questions is all good!

Selina

7

ah ha! :slight_smile: I didnt see that one - such a long list…

it looks like ill need to get a grip on the evaluate DAT, as ill want to dynamically adjust all the params of a ramp, and multiple points at once…using the substitute DAT seems a little clunky to do for a bunch of points on a ramp.

for now, this has been a huge help! thanks…

m