Replace Multiple Characters?

[iXPhound]

Hi All:

Hopefully this is an easy one for the more experienced out there. I have a field that contains a rather lenghty string. In this string I want to remove multiple "sets" of characters: "CN=", "OU=", "DC=", and so on. I tried doing a replace: Replace(fld, "CN=", "&quotbut I am not sure how to do more than one replace. Any ideas are greatly appreciated.

TIA!!

 

[iXPhound]

Please help! Im new to this and I can't find assistance anywhere.

 

[lyanch]

you can do it one of two ways..

assign it to a variable:

stringvar excluded;

excluded := {table.field};

excluded := replace(excluded,"xx",""
excluded := replace(excluded,"yy",""
etc..

excluded

or two.. embed them (i like the one above better)

replace(replace(replace({table,field},"xx","&quot,"yy","&quot,"zz","&quot

Lisa