JavaScript to CSV/Excel

[timmbo]

Hi All,

I'm attempting to pass information via JavaScript to Excel via CSV format. I have a field that dispalys as Bank Name, Bank Location.

Example: Money Bank, Somewhere USA

When I migrate the field to Excel, Excel populates the information in two cells not one.

Example: Cell1: Bank Name Cell2: Bank Location

I would like it to stay in one cell. I'm sure it has to do with the "," in the field. But not sure how to get around it. If anyone has any suggestions, I would appreciate it.

I am doing this using a reporting tool called Actuate. Below is the line I'm attempting to do this with.

self.location.href="../viewer/searchreportpage.jsp?id=" + id + "&connectionhandle=" + connhandle + "&name=srs_cpy_acknow.roi&format=CSV&startingPoint=0&CPY_ACK::Frame5::BankLocation:select=true";


TIA,
Tim

 

[adam0101]

Try enclosing the value with double quotes.

Adam
while(ignorance){perpetuate(violence,fear,hatred);life=life-1};

 

[timmbo]

Adam, that did it.

Thanks