How to setup "Add a row" with value containing quotation mark and comma
My example includes inch as an abbreviation ("), along with a comma followed by some text.
How do you add this particular value in your Tables: Add a row values?
Example value:
1", test
Is modifying my value, using Text: Find and replace, my only option for adding my example value via Tables: Add a row? In this case I do not need a table formula since I am modifying one field.
Since the value contains a comma, I tried enclosing the value in quotation marks. This creates the value below and only the number 1 appends to the destination column.
"1", test"
The value also contains a quotation mark, so I tried escaping it with quotation marks.
""1", test""
This last option creates a fix task with the following message:
There was an error parsing values: Trailing quote on quoted field is malformed. Please ensure comma-delimited inputs are formatted correctly.
Comments
-
Using Text: Find and replace, to replace " with "", adds the value into my table successfully.
"1"", test"
5