Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

File Content Conversion - Double Quotes on Output Fields

Experts - I was not able to find a scenario similar to mine via searching, perhaps you know a solution:

I need to create a CSV file with the structure:

"FIELDNAME1","FIELDNAME2","FIELDNAME3","FIELDNAME4"

"value1","value2","value3","value4"

"value1","value2","value3","value4"

From structure:

<userlist>

<userinfo>

<FIELDNAME1>value1</FIELDNAME1>

<FIELDNAME2>value2</FIELDNAME2>

<FIELDNAME3>value3</FIELDNAME3>

<FIELDNAME4>value4</FIELDNAME4>

</userinfo>

<userinfo>

<FIELDNAME1>value1</FIELDNAME1>

<FIELDNAME2>value2</FIELDNAME2>

<FIELDNAME3>value3</FIELDNAME3>

<FIELDNAME4>value4</FIELDNAME4>

</userinfo>

</userlist>

So, using the Content Conversion parameters:

userinfo.fieldSeparator = '0x09'

userinfo.addHeaderLine = 1

userinfo.endSeparator = 'nl'

So, using this configuration I can get the general structure, but without the double quotes around ALL values.

Is there a Content Conversion setting that can be used to enclose the output strings in double quotes?

Former Member
Former Member replied

Hi Tadd,

Your FCC should be like this:

And my FCC is:

user_info.fieldSeparator = "," (doublequotes + comma + doublequotes)

user_info.endSeparator = "'nl' (doublequotes + newline)

user_info.beginSeparator = " (double quotes)

Dont put any space in between the characters. Try this and let us know the output. If you put the above parameters then i feel you should get:

"Bob","Jenkins"

"Mike"," Smith"

Regards,

---Satish

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question