Left on all list items?

[pctechtv]

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 1^st one only. How can you use Left with a list and make it shorten every Item in the list?

 

[comment]

How can you use Left with a list and make it shorten every Item in the list?

 

One by one, using a recursive custom function (or a looping script).

 

Note that this would be trivial if the values were individual records. Filemaker's understanding and manipulation of return-separated lists is very limited compared to data stored in the fundamental records/fields structure.

[bruceR]

To expand on Comment's comment:

 

Why do you need to do this in the first place?

 

It would be helpful if you would present a bigger and more complete picture of what your solution does and how the data is structured.