Hi, we need to output an Excel file where each column of text is surrounded by '' ie. 'column 1' 'column 2' 'column 3' etc. Is there a tool which can do this?
Yes, it only works on the string values. If you want to apply them you would need first to switch the field to string. Otherwise it is impossible (even by forcind an < "'"+ tostring([_CurrentField_]) +"'" >.
Antother way would be to copy and create new fields, which would be appended to the ones already exsisting, leaving your current ones untouched to keep working on them.
Regards
Use the multi field formula and use the following expression < "'"+[_CurrentField_]+"'" >
It's less manual than doing it on the formula tool
Configured like this:
Hi @LizPerry,
I'd suggest using the dynamic rename. If you'd configure it like this it will work.
Best,
Yalmar
Hi and thanks Yalmar, that only seems to enclose the column headings though not the data in the fields as well which is what I need. Thanks, though! :-)
