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
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.