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.
5 Replies
-
Could you please provide some sample data, e.g. the CSV file including the quotes?
-
I would like to provide a sample data file but that is not allowed here.
Maybe a screendump can show it.
-
Hi Hans,
you can upload files in posts. Just choose attachements.
Cheers
Joerg
-
Are we talking about the same thing?
I have no option attachment to choose. I guess that you do not mean insert/Edit image?
Hans
-
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