Substituting a list using another list

I have a variable $$headers which is a list of values
valueone
valuetwo
valuethree
valuefour
valurfive

etc

I want to take multiple items out of the list that are not necessarily in the order they are in the list using substitute based on a list in a field.

Let(
[
thelist =Substitute ( Table::Field; ¶; """;""""];[""")
;
leftlist = Left ( thelist; length(thelist)-3)
;
rightlist = right(leftlist;length(leftlist)-6)
]
;
Substitute ( $$Headers; rightlist)
)

when I am testing, rightlist is as expected
["valueone";"""];["valuethree";""]

but the substitute function errors...

I essentially want my list ($$Headers)to stay in order, minus the list in Table::Field

If I copy the results from Rightlist into the substitute function it works (yes I have extra lines that's a different issue), but passing it in from a let statement doesn't.

Any ideas??