Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My data has a column called Keywords where some of the keywords have quotation marks " or brakets []. For example:
"yellow house"
"yellow gate"
[red house]
I would like to clean this field by removing quotations and brakets so it looks like this:
yellow house
yellow gate
red house
How can I do this in QV?
Thanks
Hi,
Use the function PurgeChar:
PurgeChar(FieldName, '"[]')
Hope that helps.
Miguel
Hi,
Use the function PurgeChar:
PurgeChar(FieldName, '"[]')
Hope that helps.
Miguel
Thanks Miguel. Works perfectly.