Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Is there a way to put tick marks around the values in a column? I have tried numerous ways, and cannot get a formula to work that puts tick marks around every value in a column.
I need ticks around the values to make the Dynamic Input tool work.
For example, I have the column, "OrderNo", and I want the values to have a single tick in the front and in the back: '12345'
Operating system used: Windows
Hi,
There are various ways this can be achieved.Among them, one of the most straightforward and flexible options is to use the formula processor in a Prepare recipe.
In here, do a concat of single quotes around your column value. For example, see Capture.PNG. In my example I put the output to another column, but it can be done in-place too.