[Solved] Commas in values submitted affect CSV fil

Welcome, Guest
Please Login or Register. Lost Password?

Main Forum for redFORM

Page: 1

TOPIC: [Solved] Commas in values submitted affect CSV fil

Forum Tools

2010/01/08 20:51 #5287

[Solved] Commas in values submitted affect CSV fil
If a submitter includes a comma in something they've written in a field in a RedForm form, the CSV file reads it as a comma to separate, which messes up the alignment of the data in excel. I believe this is also the case if there's a comma in the label for a field. Can something be done about this?

Last Edit: 2010/01/11 19:21 By admin.

Offline

The administrator has disabled public write access. Top

Beth

Senior Boarder

Posts: 65

2010/01/08 22:23 #5290

Re:Commas in values submitted affect CSV file
Normally, the comma should be escaped (with a '\' i think), so the csv reader should not have a problem with it.

Offline

The administrator has disabled public write access. Top

julienV

Moderator

Posts: 961

For all support request, please provide your current versions of joomla, and of the redcomponent extensions.

2010/01/08 22:52 #5291

Re:Commas in values submitted affect CSV file
Well... I just clicked CSV Export from the back end and opened the file in Excel... Do I have to do something fancy like saving it and then opening it in Excel?

Offline

The administrator has disabled public write access. Top

Beth

Senior Boarder

Posts: 65

2010/01/09 19:15 #5295

Re:Commas in values submitted affect CSV file
Tried saving it and then opening from excel and that didn't produce different results. I'm using Excel 2003, in case that makes a difference.

Offline

The administrator has disabled public write access. Top

Beth

Senior Boarder

Posts: 65

2010/01/11 19:20 #5316

Re:Commas in values submitted affect CSV file
There is an update to CSV files in the next releases. Beyond that remember to import from text with CSV files - never open them directly in excel.