How to extract specific data?


I am trying to only get the fields from my "Crew HQ Code" column that have an "L" as the third letter. Everything else, I don't want in my data.

For example, from my picture, I would only want to see those rows with PWLBF, PWLEB, and PWLSX.

I was thinking of using an IF and a Substr statement, but I can't seem to get the IF statement to work.

Does anyone have any ideas? Any help would be appreciated. Thank you


Here are a few ideas that seem like possible solutions:

Thank you, that worked!

1 Like