Hello-

First post here, hope I'm giving all the necessary information! I'm doing content management, working on an online application for jobs with my group. Using the dataform, we have people input their information, and paste in a copy of their resume. We export this data to a CSV file, then import into Access. Each record ends up in Access, then in Excel, then eventually into a mailmerge in Word that gets sent to the interviewer (not ideal, I know, we're working on it).

Everthing works fine except the resume, which ends up with lots of extra rando characters, all one paragraph (no line breaks) etc. Currently "Resume" is a Text Area. When we fliped the resume field to an HTML  Area, we got all the HTML code in there, so that didn't help.

One thing that has worked is listing all the entries -- in that new page, it shows mostly proper formatting (no rando charicters, line breaks, etc), and then you can select, copy and paste direct into Access. But that doesn't work very well when we get hundreds of applications weekly.

Any ideas to make this conversion? We want to end up with plain text but proper spacing, line breaks, etc -- we just want basic formatting with spaces between paragraphs, etc.

Currently running WebGUI 7.4.35

Form is here, for whatever reason: http://www.greencorps.org/apply

Thanks for the help in advance!

Jesse Littlewood

--- (Edited on 5/23/2008 1:04 pm [GMT-0500] by jlittlew) ---