Isssue description:
I am looking up a text field (DefaultOrderType) in the Orders table from the Suppliers table, based on a number (SupplierID).
In the Suppliers table the DefaultOrder type is "n" characters long (e.g. 6 chars, "IN-OUT")
In the Orders table the looked-up DefaultOrderType will be n+1 characters long (e.g. 7 chars, "IN-OUT¶") – thus a carriage return [ char(13) ] is added during the lookup.
I believe this is some unexpected behaviour.
Hi,
Thanks for taking care of this.
I am on a vacation trip right now, I'll catch up and edit your sample file
next week.
Kind regards
Gergely
TSGal <noreply@filemaker.com> ezt írta (időpont: 2018. aug. 16., Csü 23:50):
Re: FM adds a carriage return to the end of a lookup field
reply from TSGal
<https://community.filemaker.com/people/TSGal?et=watches.email.thread> in *Report
a Product Issue* - View the full discussion
Dear TSGal,
Having got back from vacation I checked the issue once again. I need to apologize, because the extra ¶ was not a systematic error of the lookup field, but was due to the erroneous definition of the custom function VLOOKUP that I1ve been using in my solution.
Issue closed, sorry to have kept you up with this.
Kind Regards
Gergő
GUBACSI Gergely
ügyvezető / managing director
texas0478:
Thank you for your post.
I am unable to replicate the issue. I have enclosed a sample file that looks up the DefaultOrderType text field from the Suppliers table based on the SupplierID number field. Let me know what I am doing differently than you.
TSGal
FileMaker, Inc.