In column C I enter a function CONCATENATE, which allows me to merge texts that are included in column A and B. Then, in column B, in each row, I put OR (to be specific: space OR space). What I need to do is to clean it – remove rows with single letters. In column A, that includes my data, it goes down and reaches 152 records. I thought to myself that there must be a smart way of building the super long string with excel. When I saw it, I imagined myself rewriting names one by one with “OR” operator between each, and what I said was: no way! Let’s look at Wikipedia’s list of Polish female names: One of the most extended strings I’ve ever used was when I was trying to find a female candidate for a particular role, and I decided to use the “first name method.” I needed to find a list of most common names in the country I was working for and I turned it into a boolean string. If someone is new to sourcing and only learns about boolean from the internet, it might be intimidating to see the length of some boolean strings. No matter what the platform that you’re sourcing on, you’ll most probably use boolean to include many keywords for the same search. This article is part of a series called Editor's Pick.īuilding boolean strings is one of the first things that every sourcer should learn.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |