Convert list of string to list of numbers

[shefali]

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]

[shefali]

Hi Shivakumara,

Thanks for the response. The function you've used appears to return a string variable containing integers. However, I need to first extract a list of integers. Then, I can use existing list functions to determine the minimum and maximum values from the list.

I am able to perform this operation on a list of numeric strings. However, the issue is that the min and max functions are returning values based on ASCII character order rather than numerical values.

If you feel there is an alternate way to handle this using existing functions, please guide me 

[shivakumara]

Hi @shefali ,
I found another way doing it is 
1. when the input is "List of String" pass it to another variable where it should of data type "Integer"
2. Workato will take care of your "List_of_String" to "List_of_Integer"
3. Apply formulae "MAX" or "MIN" whichever you needed as per your requirement

Here are some screenshots for your reference:

[Prudvi]

Thanks @shivakumara

[shivakumara]

Happy to help.  @Prudvi  🤗

[shefali]

HI Shiva, 

I tried passing a list of string to a new variable of type integer. O/P is still a list of string. The auto -conversion is not working for me.