AnsweredAssumed Answered

Creating a CSV from a Flat File with wildcard (*) characters

Question asked by weston_rossborough on Nov 13, 2017
Latest reply on Dec 5, 2017 by murali.yekola335627

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

* Etc.

 

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?

 

Thanks,

Weston

Outcomes