AnsweredAssumed Answered

Re calculation field

Question asked by mark_d2x on Nov 16, 2009
Latest reply on Nov 17, 2009 by mark_d2x


Re calculation field




I am using a calculation field to supposedly help when I export the file as excel for uploading as a .csv file.


I have used the following calculation:


"\"" & FIELD TITLE & "\""


I then save records as Excel.  Open up the xls file in Excel to finish off the data everything looks fine e.g. "James" - but when I open in a text editor it is showing as """James""" etc


If I repeat without the calculation field the xls file has James as does the csv opened with a text editor.


What am I doing wrong?


This is doing my head in!