DATA Step, Macro, Functions and more

how do I find words in text using find()

Accepted Solution Solved
Reply
Regular Contributor
Posts: 199
Accepted Solution

how do I find words in text using find()

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.


Accepted Solutions
Solution
‎06-30-2016 05:54 PM
Super Contributor
Posts: 441

Re: how do I find words in text using find()

[ Edited ]

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.

View solution in original post


All Replies
Solution
‎06-30-2016 05:54 PM
Super Contributor
Posts: 441

Re: how do I find words in text using find()

[ Edited ]

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 210 views
  • 0 likes
  • 2 in conversation