Hi, so is substitute supposed to behave like this:
The wildcard works for the incoming but not the outgoing ( “After” )
I just want it to append the cells themselves.
I think you want the eval dat instead.
Substituting is great if there’s a special character that you want to uniformly replace, though less useful if you’re just trying to append or prepend some text.
Take a look here to see how you might use these two DATs in different ways:
base_append_text.tox (710 Bytes)
Thank you Matthew! Eval it is, I have been tentative to using it for fear of adding eval level cooking, but as long as I filter its use case down to only when I need it it wont cook a lot at all.
I’d argue this should work. It’s also pretty counter intuitive of the DAT to accept wild cards in one field and not the next.
Yes, we recently had an internal discussion about why it didn’t behave as you were expecting. I thought it did already, but it’s actually the channel renaming in the Select CHOP that does that pattern replacement. (Now a RFE)
So then we resorted to the Evaluate DAT, which is more verbose and less flexible. There are some examples similar to yours, Matthew, in the next OP Snippets in 099.
But also in your example, where did you find out about the second-input of the Substitute DAT? It’s not documented and I’ve never heard of it! Thanks for that.
hahahaha!
Some very aggressive testing and fighting with that operator to figure it out. I figured it had to have a two column requirement, and then just wrestled with it until it behaved. 