Hi there,
Tried to use a CSV for datafeed. Succeded, but was not able to mask the quotes; didn't work like it should. What could I have done wrong?
Please help.
In reply to Hi, I passed the 1st by kperlich
In reply to Michal just published a new by sstein
Hi Hans,
The intention of the masking character is the following:
Any text enclosed by a pair of the specified character will be protected from being parsed for the separator character, i.e the string will not be split into columns even if it contains the separator.
For example, consider a CSV-Table like this:
Historical person,Citation
Julius Caesar,"veni, vidi, vici"
This is what e.g. Excel will create if you use the separator character within a cell and save as .csv
In MashZone, the " marks will protect the phrase "veni, vidi, vici" from being split by the comma. However, they will not be removed from the result.
So, the masking option is not about getting rid of some chars. To achieve that, you can use the "Replace text" operator, replacing " by blank.
Cheers,
Udo
