put here some examples of that "notes" field.
Hi Ray, here is an example of the notes field I need to parse:
11-10-10 SENT APP TO WMP W/CK/267. FAXD SANDY EKEY REQUEST FOR BPM & EKG. ORDERED APS DR JOHN WWW 123-8765 FAXD TO 123-4322 (IA-62). FILED 11-16-10 ENTERED POL# PER WMP PP PER GREG H2222222 NEED TO WITHDRAW APP - SAID FAMILY ISSUES AND CLIENT DOES NOT WANT TO PROCEED. TT SANDY CANCELLED MEDICAL. TT RECD FAX FROM VERISMA NEEDING LETTER OF AUTH. TT TONI @ 123-456-7404 @ VERISMA CANCELLED APS REQUEST.
Am I right that there are two dates inside that note ?
There is always a full stop before a new date ?
Which have to be the final wished result ?
And how consistently formatted are your date entries?
1. Yes, there are two dates in that note
2. I'm not sure what a "full stop" is, if it's a period then no there is not always a period before a new date
3. I want to be able to parse the dates and connected notes into seperate records (I have ID's for each customer) with a noteDate and a noteText field, this will form a new relational table along with the customer ID. When the user brings up a customer a dated list of notes (in a portal or whatever) will be able to be viewed as well.
:-) not very ... The only consistant thing about these notes is that the first note date appears as the first "word" in every note.