how do I find words in text using find()

[gzr2mz39]

permit is a text field with length 40.
facility is a text field with length 60.
facility_hmbp_3 = scan(facility,3,'') with length 40.

If facility_hmbp_3 is equal to Lewis then the variable find_hmbp should be 6 for permit="OCEH Lewis Sub" where find_hmbp=find(permit,facility_hmbp_3,'i').
However, I'm currently getting 0.
If I change find_hmbp=find(permit,"Lewis",'i') then I do get 6.
Why am I not getting 6 with find_hmbp=find(permit,facility_hmbp_3,'i')?

Thank you.

[jklaverstijn · Accepted solution]

Likely the trailing spaces that are implicitly present in your strings play a role. You can omit them from the comparison by adding the t modeifier to the third parameter.

find_hmbp=find(permit,facility_hmbp_3,'it')

Hope this helps,

- Jan.