AnsweredAssumed Answered

Re calculation field

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

Title

Re calculation field

Post

Hi,

 

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!

Outcomes