Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Missing "0" from excel export

  • medveyt
  • medveyt's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 months ago - 7 years 6 months ago #141289 by medveyt
Missing "0" from excel export was created by medveyt
Hi there!

I've got a survey with a question, where you should write a kind of ID of 9 numbers. The ID could start with 0. When you export it in xls, it automatically cuts off the 0-s from the beginning. It's quite a problem when you want to work with the data.

I've tried it with numbers and short free text with and without /^([0-9]{9})$/ validation, but no success at export. (2.06+ Build 151018)

Any idea?

Thanks in advance!

Br,
Thomas
Last edit: 7 years 6 months ago by medveyt. Reason: missing ")" in validation
The topic has been locked.
  • medveyt
  • medveyt's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 6 months ago #141290 by medveyt
Replied by medveyt on topic Missing "0" from excel export
Found a workaround:
/^([0-9]{3} [0-9]{3} [0-9]{3})$/ works fine. (in "000 000 000" format instead of "000000000")

But I'm still interested, if I could use it without any workaround.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 6 months ago #141310 by holch
Replied by holch on topic Missing "0" from excel export
The problem is excel I guess, because with short free text it should work. Have you tried to export via CSV and checked what is written there. I would guess the "0" is still there.

But Excel usually cuts of trailing zeros.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose