Find JOIN and , between FROM and WHERE clause

**amandeepsharma89** · 02-11-2013, 08:29 PM

Hi,
I am in a fix and following is my problem. I am novice in excel and I would need help in the following question.

I have a list of 6000 queries in column A. All the queries are very different from each other.

I need to find if there is the word "JOIN" or "," (comma) between the word FROM and WHERE in my query then return FALSE. However in some cases I do not have WHERE after the FROM clause in such a case I need to see if there is a "JOIN" after the FROM clause and if there is, then FALSE, no need to find "," (comma) in this case.

Your help is really appreciated as I need to fix this asap.

Thanks,
Amandeep

**vlady** · 02-11-2013, 09:12 PM

maybe a sample workbook copy on how the data are arrange with possible combination of those comma,where,and sample expected outcome...could help you receive responses.

**amandeepsharma89** · 02-11-2013, 09:26 PM

I have attached a sample excel with the expected results.
Waiting to hear back!

Amandeep

**vlady** · 02-11-2013, 09:51 PM

can you check this one.

Formula:

Please Login or Register  to view this content.

Note: not tested on other instances of combination possible.

**amandeepsharma89** · 02-11-2013, 10:21 PM

Hi vlady,
You are almost there. In the attached excel if you see in row 7 the answer should be TRUE as there is no "," or "JOIN" between FROM and WHERE but as there is a comma in WHERE. I am getting a FALSE (your formaula did not take this into consideration as I did not mention properly in my requirement). I put my requirement incorrectly and I am sorry for that.

So, most of the part is correct but in some cases there can be a "," after WHERE. In this case when there is NO "JOIN" or "," between FROM and WHERE but a "," after WHERE then I want a TRUE.

If this case is solved one of my major problem is solved.

I would really appreciate your help in this.

Waiting for your reply.

Best,
Amandeep

**vlady** · 02-11-2013, 10:36 PM

base on your given output try this now. Thanks.

Formula:

Please Login or Register  to view this content.

**amandeepsharma89** · 02-11-2013, 11:00 PM

Hi Vlady,
The above formula is given me the wrong result for most cases but the one above that gave me the right result in most cases except the case that I gave you on row 7. Can you please look it up what is going wrong. In the sample excel sheet it works perfectly but not in the original sheet. In the original sheet 1st formula works better.
Waiting for your reply.

Best,
Amandeep

**vlady** · 02-11-2013, 11:29 PM

hmmm.
you can try this one
=IFERROR(IF(SEARCH(",",A2,SEARCH("WHERE",A2,1)),TRUE),IF(OR(IFERROR(SEARCH("Join",A2,SEARCH("From",A2,1)),FALSE),IFERROR(SEARCH(",",A2,SEARCH("From",A2,1)),FALSE)),FALSE,TRUE)

Find JOIN and , between FROM and WHERE clause

LinkBack

Thread Tools

Rate This Thread

Display

Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Re: Find JOIN and , between FROM and WHERE clause

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions