Systematic Community

shefali · 2 weeks ago

Is there a formula that can be used to convert list of String variables to a list of integers ?

I/P is ["1","100","50", "4"]
O/P [1,100,50,4]

shivakumara · a week ago

Hi @shefali,
If you observe my screenshots:

1️⃣ In the 2nd and 3rd images,
I used Variable_name: List and Datatype: String. When applying the pluck("v") formula, it automatically converts to List_of_Numbers, so there's no need to explicitly set the data type as List.

2️⃣ I have a small curiosity: Why do we need to create two variables with Integer or Number data types to parse a number list?
Answer: There's no need to use two variables. As I suggested, when we apply the pluck("v") formula, it automatically takes care of converting to List_of_Numbers.

3️⃣ However, when using list functions, it still treats the variable as a list. Shouldn't it actually be recognized as a number instead?
Could you please share a screenshot? I didn’t fully understand your point here.

Looking forward to your insights! 😊

Thanks and Regards,
Shivakumar K A

View solution in original post

shivakumara · a week ago

Hi @shefali ,

We should be able to apply the min or max formula directly after using pluck("v"), but since our formulas are applied to the input rather than the output, applying Max or Min will be on the "List_of_String" not on the List_of_Integer. I hope it is clear for you

Thanks and Regards,
Shivakumara K A

Systematic Community

Convert list of string to list of numbers