See below my Workspace to generate a CSV file from a SQL View:
The CSV looks good except I need to put double quotes (“ “) for certain text strings. For example under Ledger Type column, AA should be ‘AA’.
Please let me know which of the String Function(s) in AttributeManager I should use to put double quotes around text strings (or other Transformer you deem more efficient):
Also, how can I replace all the comma separators in the CSV file with pipes character ’|’ instead.
Many thanks!
Best answer by ebygomm
fmesafejde wrote:
Worked like a charm @Mark Stoakes
One thing though.. somehow the CSV file format adds additional 2 more pair of double quotes to the text string even though i only defined as one pair of double quotes:
Believe it is more of a CSV file issue. Is there any workaround to only show one single pair of double quotes?
I suspect you've got qualify field values set to "As needed", values with quotes will then get additional quotes added.
If you change this value to "No" you won't get the additional quotes
One thing though.. somehow the CSV file format adds additional 2 more pair of double quotes to the text string even though i only defined as one pair of double quotes:
Believe it is more of a CSV file issue. Is there any workaround to only show one single pair of double quotes?
One thing though.. somehow the CSV file format adds additional 2 more pair of double quotes to the text string even though i only defined as one pair of double quotes:
Believe it is more of a CSV file issue. Is there any workaround to only show one single pair of double quotes?
I suspect you've got qualify field values set to "As needed", values with quotes will then get additional quotes added.
If you change this value to "No" you won't get the additional quotes
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.