Formula to put Tick Marks around values in a column?

FarSideFeb
Level 3
Formula to put Tick Marks around values in a column?

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

0 Kudos
1 Reply
MiguelangelC
Dataiker

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.