I use pulldata () function and got the values a text format for number; e.g: in the .csv external file it comes as a text ‘500,000’ . I want to convert it to an integer 500,000. What is the function to convert this text into a number.
@lazasoa, you could use the
int() function or the
number() function to convert a string to an integer as outlined in the image shared below:
In the survey tab of your xlsform:
Data entry screen as seen in Enketo:
String to integer.xlsx (10.6 KB)
@Kal_Lam Thank you so much. It works!
Hello @Kal_Lam. in the case of use a calculate the data result have a apostrophe, for example: '52 , there are a way to transforme in to a number?, for example only: 52.
Welcome back to the community, @Erosfaus! Have you tried checking and unchecking this option to see if should solve your issue:
Hello @Kal_Lam , not yet, but i will try.
hi @Kal_Lam , i have the same issue as @Erosfaus . I have tried using number() / int() with the pull data code as well as this suggestion of checking and unchecking the option, but it did not solve the issue. my data from calculation items is still read as text instead of numeric.
do you have a sample on how to properly apply the number() or int() with the pulldata function? i think this is where I am doing something wrong-- number(pulldata(a,b,c,d))?
Where do you see it as “text”? If this is in your export only, it probably depends on your (advanced) download settimgs: Do not use legacy, and select text as numbers option)…
hi @wroos, it is when exporting the raw data. here is my current download settings
@hm11, please be informed that data fields pulled from a .csv file are considered to be text strings, therefore, you use need to use the
number() functions to convert a pre-loaded field into numeric form. You could do this in a