Testing for "@"

[Mark Brown]

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

Topic

[bill bearden]

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

[Mark Brown]

That did the trick!

Thanks!

[Author]

Replies