File Dataset - how to escape quotes character in a string
Hi. Has anyone any insight on how to configure a file dataset to ignore the quotes character within a field? the team tells me we have tried inserting a preceding \ (back slash) assuming Java String processing, but without success.
Pegasystems Inc.
GB
@healj We can 'suppress' the double-quote by preceding it with another double-quote character, but we want to preserve the data i.e.
"Samsung Galaxy S2, 9", black case" - causes an error.
"Samsung Galaxy S2 9"", black case" - results in property value "Samsung Galaxy S2 9, black case"
Pegasystems Inc.
GB
@healj The pattern we have settled on for now is to specify 'Custom supported quotation marks' and use a ~ (tilda) to enclose string fields.
~Samsung Galaxy S2, 9", black case~ results in "Samsung Galaxy S2, 9", black case"
The problem is that the tilda character is also appearing in some of the string fields!