Hi all,

I have a paragraph delimited list of values in a single global field.

ABC123

ABC234

ABC345

No spaces and a blank line at the end.

I am using leftvalues(thatfield ; 1) to take the first value and place it in a newly created key field. The result is 3 new records each with its own value.

The problem is that sometimes each field populates normally with the paragraph return being stripped out and other times each value will be followed with a paragraph return.

Has anyone seen this?

It's always there unless it's the very last. It's so annoying that I usually make a custom function to get rid of them take a look at my script in this thread:

http://fmforums.com/forum/showtopic.php?tid/169095/

The issue is that sometimes do you need them if say you pluck 3 items...

--sd

(It appears that I left something out on the post above because it's not clear if I was stripping the paragraph return or not - I've since changed the scripts.)

The problem is that it was not consistent.

This is in a solution written in FM6 and converted to 7/8. The parent key file was written in 6 but the foreign key file was written in 7.

This is used cross-platform and hosted on a Mac Server so if it's a bug, it doesn't appear to be platform specific.

I'm just posting the reply in the event someone else has seen this.