4 Replies Latest reply: Jan 20, 2014 9:56 AM by Staffan Johansson RSS

    Read between two words

    Staffan Johansson

      Hi I try to read text between two words, I use today TextBetween and it works when I have the second word.

      Sometimes I dont have the second word and then it fail to read that line.

      In my example I read: textbetween(Statement,'FROM ', 'WHERE' ) and this will give me the datasource, but sometimes ther is no WHERE statment in my query, any Idea?