I have case here, I would like to create an index with phone numbers in it. The phone numbers could be coming in different formats with spaces and special characters in it. I would like to create a new derived field with no spaces and special characters in the new field. I see there is pattern replace, But i would like to use copy_to as well.
Please let me know , thanks in advance.