franknove

I would like to filter a date range within a portal using two fields with a drop down calander. Any one like to make some suggestions?

Hello Lee, Thanks for your help. I am trying to clean up our Accounting System Database to export the data to a CRM package. The Accounting System has two lines of data for names, and basically over the years the information has been typed in in various permutations as per the ones you outlined in your previous response. Sometimes we commence with "Mr" "Mrs" etc, and other times we only use initials where the full first name was not obtained. I know that it is going to be impossible (at least I think it is?) to cover all the permutations, however I have ascertained that the two most common forms of data imput are those I stated in my initial query. If we can find a solution for the two outlined, I can then go through and gradually clean up the remainder. Thanks again. Frank

I have a file which can contain one name such as John Smith or two names such as John Smith & Betty Brown. When there are two names they are separated by an "&". I would like to extract name 1 into two fields Contact1Name and Contact1Surname, and if a second name exists extract it into Contact2Name and Contact2Surname. To complicate matters, sometimes the surname is only included once in the data at the end as - "John & Betty Smith" Is it possible for the calculation to take into account that there are sometimes 4 names and other times 3? Any assistance would be appreciated.

I have a field which contains Suburb and State. Sometimes suburb can be one, two or three words, and state is 2 or 3 letters. I would like to separate suburb. I have managed to pull out state using "rightword".

Thank you Lee, it worked

I have a file which can contain one name such as John Smith or two names such as John Smith & Betty Brown. When there are two names they are separated by an "&". I would like to extract name 1 into two fields Contact1Name and Contact1Surname, and if a second name exists extract it into Contact2Name and Contact2Surname. Any assistance would be appreciated.