Can anyone aid me in renaming 2 values within a field within the script?
Field = [Salesperson]
I would like to change "Sue" to "Susan" and "John" to "Jonathon".
I have already tried if(Salesperson='Sue','Susan', AND if(Salesperson='John','Johnathon', Salesperson) as Salesperson
It doesnt work. The field Salesperson comes from a QVD with more than a 100 values.
I do alternatively have the SalespersonID field if something could be done from that?
Aaron, did Vegar's adjust post get things working as you wished? If so, be sure to come back to the thread and use the Accept as Solution button on his main post to give him credit for the help and to let others know it did work. If you are still working upon things, leave an update.