i have a script that renames details with their sheet numbers. we have added some offices and so we had to added some suffixs to the numbers for regonal variation. i was able to weed out the suffixs but when i recreate the list it changes the order of the list. any sugestions how i can maintain the list order?
for clarification i could just find and replace the “-mid” but that is just the one of the many sufixs and they could potentially increase as we expand.
Hey,
If I understand the problem correctly…
So your boolean filter strategy filters off the items you are interested, but then they are out of step with the data streams which have not been filtered?
So as I see it, you have 2 strategies…
- Copy your boolean filter down to your other data streams, keep the same mask… Then you can repeat the ‘join’ node on those other data streams and your data will be consistant.
- Instead of the boolean filter, use a strategy of replacing at indices… note the indices, grab the ones you want, edit them, and reuse the indices to replace the old values.
Hope that helps,
Mark
maybe if the seperator is always “-” use string split? that way the order of the list remains the same.
1 Like
Hola amigos buenas. 
Amigo @DangeRuss I always like to play with the index of the items, add one step to your script:
1 join both list afther the boolean mask.
2 then ask the index of the original list.
3 ask the item at index from the replaced and joined list to retake the original order, i let you an example.
dude thanks… this is a way easier method!