Hello,
I am trying to parse text i have inserted into an array (attaching image):
at the end of every array item there are () containing the date.
I wish to add another field in my array so every item will get separate attribute of the “value” and the date.
Any recommendations?
1 Like
Hi @Gilad1
After match pattern, you can apply functions over the value like {{first(split(value;(;))}} or last and then convert that into array if you want array structure.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Thank you, this is what i did with set variable step :
But, now im trying to find a way to add other values in the same order into the array - If ill do another text parsing to extract the date pattern, how can i set the right values in the right order?
1 Like
You will need to iterate anyone array and then use bundle order position from iterator to get the right value from other array if you want in sequence.
Also, you can try array aggregator as well in place of set variable, Where you can use group by field with functions over your value to split. and then in next step you will only have to use function over the value and one value you will already get as key. So you won’t need to match the variables.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
Any chance to see an example? Im not sure how to practically do that 