1 Reply Latest reply: Oct 6, 2008 7:56 AM by 807589 RSS

    Regex - Find a word

    807589
      Greetings all

      I want to find a particular word in a string
      example string: SELECT CUSTOMER.STUDENT."NAME", CUSTOMER.STUDENT." FROM DATE" FROM CUSTOMER.STUDENT

      i want to grab the FROM WORD from the above string .
      search condition: There must be a space before and after the FROM word and FROM word should not contain double quote before and after.

      as you can see in the above string there is a string named " FROM DATE " .this string also contains FROM word , i want to exclude this type of FROM word .

      your advice and suggestion would be great :)