Hello Celopeers.
I have a variable that is a list based on a dropdown component.
The end result looks something like this:
'0014','0191','0311'
Now I want to pull a specific value from this variable.
Problem is, that any function calling it is either pulling only the first value, or doesn't really give me the value I need (in this case a second or third value)
Examples I tried already:
1.
Input:<%= VARIABLE%>
Output: 0014
2.
Input: RIGHT(<%= VARIABLE%>,4)
Output: Error, Operator 'RIGHT' requires 2 inputs but 4 were provided.
3.
Input: CONCAT(<%= VARIABLE%>)
Output: 001401910311
4.
While combining the RIGHT or LEFT with CONCAT might be able to be helpful enough with some tweaks if the variables had all the same length, they have varying length. some being 4 characters long, some up to 14.
Input: RIGHT(CONCAT(<%= VARIABLE%>),4)
Output: 0311
Therefore is there some way to call specific value from the list like in Python it would be:
Input: VARIABLEA1]
Output: 0191
Kindest regards
Marcin