How to keep leading zeros in data export and when combining fields | XM Community
Skip to main content
Question

How to keep leading zeros in data export and when combining fields

  • January 21, 2022
  • 1 reply
  • 199 views

Hi everyone!

Using custom validation (matches regex ^[0-9]{2}$ ) I make sure that my participants always enter two digits in response to a question, i.e. "08" must be entered instead of "8".
However, in data export and when concatenating variables, “8” still shows up as “8” even though “08” was entered.
 
However, I would also like to export (e.g. to csv or excel) this result as "08" not as "8".
Moreover, I would like to concatenate combined variables in the data section and here "08" should be also used instead of "8".
 
Is this possible?
 
Thanks.
 
Best

1 reply

StephH72
Level 2 ●●
Forum|alt.badge.img+16
  • Level 2 ●●
  • January 25, 2022

Hi,
I'm not sure how to force the export to keep 0's in, other than potentially capturing them as embedded data and putting a ' at the beginning.
Alternatively in Excel if you're trying to concatenate them then you can use the below formula to make 8 concatenate as 08.
TEXT(A1,"00")
Assuming value 8 was in cell A1. This result is 08.
So you can concatenate like this:
=CONCATENATE(TEXT(A1,"00"),TEXT(B1,"00"))
Hope this helps!
Steph