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.
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.
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))?
Hello @hm11,
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)…
@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 int() or number() functions to convert a pre-loaded field into numeric form. You could do this in a calculate variable.