Concatenate field

Hi,This is a code in an agent,

FIELD ApprovedBy :=@Leftback(ApprovedBy;10) + “/”+”UMC”+”/”+”UMCLTD”;@All

I run this agent which strips the ApprovedBy field of “/umc/umcltd (lowercase) and concatenates it with “/”+”UMC”+”/”+”UMCLTD” (uppercase).

I need a code to ADD to this code to check those documents which have the common names stored in the ApprovedBy field , for example, John Doe and concatenates it with “/”+”UMC”+”/”+”UMCLTD”.

Thank you

Subject: Concatenate field

Use

FIELD ApprovedBy := @If(@Name([CN];ApprovedBy)=ApprovedBy; … you can figure out the rest);

-rich

Subject: Concatenate field

Did you try something and it didn’t work, or do you expect an answer?

Having asked that, not really sure your question is clear.

Subject: Concatenate field

Yes sir I tried. Did not work hence why I posted. Thank you.

Subject: RE: Concatenate field

So the 2nd part of my question was, it isn’t clear what you are trying to achieve.

I would post what you tried that didn’t work, and also show examples of what you expect to happen.