I have a process that is creating a CSV from a JSON that is being mapped to a flat file. The flat file is then saved as a .CSV to be opened in Excel. The JSON has a field called "Technical Description" with a string value that includes the wildcard (*) character used as bullet points.
* Example 1
* Example 2
* Example 3
This should be interpreted as a single string, but the process seems to arrange the resulting string as several separate strings. These are placed in separate cells and columns when they should be in a single cell as one big string.
Here are the settings for my flat file:
What would be the recommended way for setting this up?