Parsing data from ACT database 
Author Message
 Parsing data from ACT database


I need to parse the name field from an ACT database.  I am able to break up
this name(which is in one field) - Mr.{*filter*} S. Van{*filter*} Sr. - into seperate
strings. I use the Instr function to find the spaces and put each piece into a
string.  However, if you do a look up in ACT, it somehow knows that Van{*filter*} is
the last name.  The salutation, first name, middle initial and generation are
easy to find from the main string, however, I am having a hard time figuring
out how to find the two-part last name.  Would anybody know how ACT does this
or have any ideas how I should go about doing this?


Mon, 11 Mar 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How to get Outlook to synchronize contact data with Act

2. Retrieving data from ACT 2000

3. Retrieving data from ACT 2000

4. Export data to MS Outlook and Symantec Act

5. Act 95 Databases

6. DATA Control acts funny

7. Connect to ACT! database

8. Act database

9. VB Database Tying two forms together so they act like they are using one datacontrol

10. Stripping/Parsing data

11. parse data into flat file structure

12. Parse data within text strings


Powered by phpBB® Forum Software