Submitted by WayneK on 2019/09/25 00:14
Does anyone have a method that will add quote marks at the beginning and end of an item?  I've been doing it manually, and it gets tiresome if you're processing a lot of items.
 
I might be able to do it with my text expander software but first thought I'd check to see if someone has a method within InfoQube.
 
Wayne

Comments

This works for me:
 
1. On the Tools|Manage Fields dialog, make sure that for the 'Item' field, 'Parse if starts with '='' is checked (You can directly open the field properties through the right-click context menu for a field in the Properties pane)
2. Make sure the Properties pane is visible
3. Select desired items, e.g. by Shift-/Ctrl-clicking
4. In the edit box for the 'Item' field on the properties pane, enter '=CHR(34)&[Item]&CHR(34)' without the single quotes, press Enter
5. Optionally remove the checkmark from #1
 
If you do this a lot, maybe use a Yes/No column to automate this?
 
Voila. HTH

Hi,
 
Left's method will work quite well.
 
You can also use a yes/no field and do this on an auto-assign: A:[item]=chr(34) & [item] & chr(34), then select one of more items and in the Properties pane, check that field. You can uncheck it afterwards to clean up
 
Pierre_Admin
IQ Designer