How to setup "Add a row" with value containing quotation mark and comma

Jozef_783863
Jozef_783863 Posts: 331 admin
edited October 2019 in Questions

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