- Posts: 4
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Missing "0" from excel export
- medveyt
- Topic Author
- Offline
- New Member
Less
More
7 years 7 months ago - 7 years 7 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
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 7 months ago by medveyt. Reason: missing ")" in validation
The topic has been locked.
- medveyt
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
7 years 7 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.
/^([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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
7 years 7 months ago #141310
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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.
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.