7 Replies Latest reply: Dec 5, 2012 3:21 PM by 2Lee RSS

    Simple??? Want "INSERT" function to return blank space after a field, how?

    2Lee
      All,

      Am I just having a brain fart? I have a situation where I have a field that needs to return just one space, or a value that has a space before and after it.

      Example:

      In the text ==> I am<field>going to the office. <-- notice no space between am, <field> and going

      I want it to say if FALSE, then "I am *not* going to the office."
      If true, then "I am going to the office."

      If true, I'm simply RETURN(""); <-- This returns a blank space


      If FALSE, I have tried:

      ret="not"
      RETURN(" " & ret & " ");

      This returns "I am notgoing to the office". <-- Notice no blank space after "not"?

      I've tried

      ret="not";
      ret2=(" " & ret);
      RETURN(Insert(ret2, 3, " "));

      Still the same result. What's strange is, if I do a RETURN(Insert(ret2, *2*, " "));, then it returns "I am no tgoing to the office" <-- Notice the space between the "o" and the "t"?

      Ideas?