This should be easy but, I must be missing something. I have written an Agent to remove dashes from a phone number field. Not sure what I am missing but, it is not working.
The field is text and the entries are in
the format xxx-xxx-xxxx.
I want the Agent to run and produce xxxxxxxxxx
This is what I have for an Agent (runs on selected documents):
@Trim(@ReplaceSubstring(MobileNum;“-” ;" "));
SELECT @All
When I run it, nothing happens.
Any ideas are greatly appreciated.
Thank you.
Marcie
Subject: Remove dashes from field
Subject: RE: Remove dashes from field
The value is already in the field as the agent is to change fields that are already populated.
Thank you for your quick response.
Subject: RE: Remove dashes from field
Subject: RE: Remove dashes from field
Oh, thank you Willy. Sorry, I just do a little formula programming as I am mainly an Administrator. I guess I didn’t know that you had to actually assign the field.
Thank you so much. Have a great day & a Happy New Year.
Marcie