Problem with text values with comma

Support
1

Hi.

I'm having problems with text values containing commas. When exporting the
data to csv using briefcase, values following a comma appear on the next
column/field. Say, for the prompt/question "Other vegetables" the
enumerator types in "squash, cauliflower", squash goes into the right
column but cauliflower goes to the next column in the csv file.

How do I make the values go into the same cell?

Thanks in advance.

Best,

Vinia

2

Vinia,

My guess is that you aren't importing the data into the program you
are using correctly. The CSV specification says that if the comma is
inside quotes, it should be treated like a normal comma, and not a
cell separator. If the data is something you can share, I'm glad to
take a look at it if you email it to me directly.

Thanks,

Yaw

··· -- Need ODK help? Go to http://nafundi.com for custom features, form design, implementation support, and user training for ODK.

On Fri, May 24, 2013 at 7:10 AM, vinia viniamarciano@gmail.com wrote:

Hi.

I'm having problems with text values containing commas. When exporting the
data to csv using briefcase, values following a comma appear on the next
column/field. Say, for the prompt/question "Other vegetables" the enumerator
types in "squash, cauliflower", squash goes into the right column but
cauliflower goes to the next column in the csv file.

How do I make the values go into the same cell?

Thanks in advance.

Best,

Vinia

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

3

Hi, Yaw.

Thanks for taking the time to reply. Very much appreciated. I just found
out that the problem was with the utility I used to consolidate the data. :slight_smile:

Again, thanks for the prompt response.

Cheers,

Vinia

··· On Sat, May 25, 2013 at 5:05 AM, Yaw Anokwa wrote:

Vinia,

My guess is that you aren't importing the data into the program you
are using correctly. The CSV specification says that if the comma is
inside quotes, it should be treated like a normal comma, and not a
cell separator. If the data is something you can share, I'm glad to
take a look at it if you email it to me directly.

Thanks,

Yaw

Need ODK help? Go to http://nafundi.com for custom features, form
design, implementation support, and user training for ODK.

On Fri, May 24, 2013 at 7:10 AM, vinia viniamarciano@gmail.com wrote:

Hi.

I'm having problems with text values containing commas. When exporting
the
data to csv using briefcase, values following a comma appear on the next
column/field. Say, for the prompt/question "Other vegetables" the
enumerator
types in "squash, cauliflower", squash goes into the right column but
cauliflower goes to the next column in the csv file.

How do I make the values go into the same cell?

Thanks in advance.

Best,

Vinia

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.