email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
Not sure what is the problem here, but from the error the parser seems to think there is a substring call? Note, I changed the indentifying information in the pasted info.

[5/26/2011 11:49:06 AM] Email 2 of 6:
[5/26/2011 11:49:06 AM] Connecting to MySQL server 127.0.0.1
[5/26/2011 11:49:07 AM] Runing SQL sentence
[5/26/2011 11:49:08 AM] INSERT INTO masterdb.localoff
(email, RefID, Bride, Groom, phone, CeremonyDate, CeremonyTime, CeremonyLocation, CeremonyCity, CeremonyState, CeremonyType, OffType, OffGender, OffEthnic, Lang, Notes)
VALUES ('xxx@gmail.com', '0526481510', 'Lisa', 'Jeffrey xxxx', 'xxx-xxx-xxxx', '06 / 11 / 2011', '4:00 P.M.', 'Private Residence', 'Rockville', 'Maryland', 'Civil', 'Wedding Officiant', 'No Preference', 'No Preference', 'English', '

Ceremony Wishes: Very small ceremony desired with 2 or 3 20-year-old children and a couple close friends attending. Ceremony will be at Lisa's home., Bethesda.
')
[5/26/2011 11:49:08 AM] Error. Index and length must refer to a location within the string.
Parameter name: length.
[5/26/2011 11:49:09 AM] Disconnecting from MySQL server
I believe the problem is the apostrophy. People use them all the time in contractions and possessives. MySQL doesn't like them in text fields and as far as I can tell there is no way to filter them in EmailParserToDatabase.