Clovertech

Testing for "@"

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Testing for "@"

  • Creator
    Topic
  • March 3, 2015 at 3:16 pm #54593
    Mark Brown
    Participant

      I’m trying to create an xlate on CL6, using IF to see if a field contains an at sign “@”.  I’ve tried a few things like @@ or @@ or @”@” and nothing works.

      And once I’m past that, I need to put two double quotes (“”) in a field. Something tells me @”” won’t work.

      Basically, I’m checking for an  email address, and if not found, then replace whatever is in that field to “”.

      Any ideas?

      Thanks

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • March 3, 2015 at 3:45 pm #82131
        bill bearden
        Participant

          Mark,

          There are a few characters we have done this with. I’ve never understood exactly why but… The trick is to put the character in a temp variable first. Then, use the temp variable in the IF. So:

          COPY =@ to @at_sign

          IF PID-11.1 ct @at_sign

           Do what you want to do.

          On the second one, if you are copying an active null (“”) into a field, you can use the built-in variable, @active_null. So:

          COPY @active_null PID-11.1

          Hope this helps,

          Bill

        • March 3, 2015 at 4:06 pm #82132
          Mark Brown
          Participant

            That did the trick!

            Thanks!

        • Author
          Replies
        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.