SaveTextFile - Help CSV issue

Posted by: kirkkelly on 8 September 2017, 1:42 pm EST

  • Posted 8 September 2017, 1:42 pm EST

    <P> </P>
    <P>Using the line below will export the sheet with comma seperating the values,  I need to wrap the values in " " marks also.</P><FONT size=2>
    <P>FpSpread1.Sheets(0).SaveTextFile(</FONT><FONT color=#a31515 size=2><FONT color=#a31515 size=2>"C:\kirk.csv"</FONT></FONT><FONT size=2>, </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>False</FONT></FONT><FONT size=2>, FarPoint.Win.Spread.Model.IncludeHeaders.None, ControlChars.NewLine, </FONT><FONT color=#a31515 size=2><FONT color=#a31515 size=2>","</FONT></FONT><FONT size=2>, ControlChars.Quote)</FONT></P>
    <P><FONT size=2>Example Output from Line above:</FONT></P>
    <P><FONT size=2>7,172.26.80.182,Barlett,STAR,CTORE,TEN<BR>30,172.18.80.208,Hahnemann,PBAR,HAN,TEN<BR></FONT></P>
    <P><FONT size=2>Desired Output</FONT></P>
    <P><FONT size=2>"7","172.26.80.182","Barlett","STAR","CTORE","TEN"<BR>"30","172.18.80.208","Hahnemann","PBAR","HAN","TEN"</FONT></P>
    <P><FONT size=2> Can this be done</FONT><FONT size=2></P>
    <P><BR></P></FONT>
  • Replied 8 September 2017, 1:42 pm EST

    They are looking at adding a way to force cell delimiters in a future version.<br>
  • Replied 8 September 2017, 1:42 pm EST

    Thanks for the info.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels