Replacing an asterisk (*)

building reports webintelligence
1

I have a data file containing peoples names. If the people are no longer in the positon that they used to hold, their name has had prepended to it either the value ‘TERM*’, or ‘T*’. I can pull out the people who have a TERM* before their name (TERMThomas) without any problem. But in the case of someone having TThomas isn’t working because the asterisk is a wildcard. When I try to delete the T* using a Match in the formula, it deletes all people whose name starts with a T. Any ideas how to identify those records where the person’s last name begins T*?

scottyochim (BOB member since 2007-09-10)

2

Hi,

Try using REPLACE() function to replace * to another character and then do what you need to do with the result:

Replace([name];"*";"!")

Marek Chladny :slovakia: (BOB member since 2003-11-27)