I see that when you use Left(return separated list; 10) it gives you 10 of a count of every character in the list. So if you had 10 list items all 20 characters long in the list you just get back 10 characters of the 1st one only. How can you use Left with a list and make it shorten every Item in the list?
So, you want to alter each value in a return delimited list?
The easiest way to accomplish that would be to use a custom function to alter each value one at a time.
The custom function would need to isolate each value and alter it according to your needs (get the left 10 characters).
Here's what I came up with:
LeftList ( TheValues ; NumberOfCharacters ; NumberOfValues )
NumberOfValues > 1 ;
Left ( GetValue ( TheValues ; NumberOfValues ) ; NumberOfCharacters ) & "¶" & LeftList ( TheValues ; NumberOfCharacters ; NumberOfValues - 1 ) ;
Left ( GetValue ( TheValues ; NumberOfValues ) ; NumberOfCharacters ) )
Let ( [
V = "1234567890¶0987654321¶0000000000¶1111111111¶2222222222¶3333333333¶4444444444¶5555555555" ;
Nc = 5 ;
Nv = ValueCount ( V ) ] ;
LeftList ( V ; Nc ; Nv ) )