DSXchange

We are trying to create PAL code to remove comments from email addresses such as ROBERT(BOB).KATTER@NP.ORG.AU

Here is the code fragment involved.
With only one comment, as above, the code works well.
The residual is "ROBERT.KATTER@NP.ORG.AU" and Comment contains "(BOB)".

However, when the source data has more than one comment, there is duplication in the Comment field.
For example, from source "ROBERT(BOB).KATTER@NP.GOV.AU(FNQ)" the Comment field contains "(BOB) (BOB) (FNQ)".

From source "ROBERT(BOB).KATTER(THE HAT)@(FEDERAL)NP.ORG.AU(FNQ)" the Comment field contains "(BOB) (BOB) (THE HAT) (BOB) (THE HAT) (FEDERAL) (BOB) (THE HAT) (FEDERAL) (FNQ)".

What might be going on here? It appears that the RETYPE to null class actions are not being heeded, and the entire input is being scanned each time.

We have established that it is not permissible to use the form 0*\( | ** | \)

Thank you for your time.

You're not clearing out temp each time you hit a comment.

Try

COPY "" temp

prior to the initial

CONCAT " " temp

Stuart beat me to it. You need to clear the temp variable.

Thank you for your replies. As usual you were right "on the money".