I am trying to extract information from a price list I have in a variable in KM.
The need is to extract all lines contain different SKUs.
A SKU could be: BC 1104060
And the price list has lines like: BC 1102050-25 BC 1102050-50 BC 1104060-25 BC 1104060-100 BC 1110060-25 BC 1110060-50
What I would like is to use the Search Variable Action to extract all lines with at given SKU.
So if I feed the Search Variable BC 1104060 then I would like this in a new variable: BC 1104060-25 BC 1104060-100
I ended up using the one where it deletes the lines. This is way faster.
I forgot that I could loop over the lines. And I tried it. But my source for searching is also in a loop.
So I ended up with a For Each including a For Each looking at 4.000 lines. And this just took to long.
But the idea with deleting items not found works excellent.
I can share the macro if anyone is interested, but it is very centric to a particular task for a customer, where I am upgrading a product catalogue. And I need to find the new SKUs from a pricelist.