Parsing carriage returns to fields in an text file

Followers

October 27, 200520 yr

I have an email form that is currently not being input by a filemaker web form, therefore, I cannot break up the fields on the way in. How can I break them up once they are imported?

I have a field called "raw" that this form is pasted into. I then want calculations to automatically populate the fields that correspond to every carriage return in the field. Please help!

example form attached below:

New hire setup information has been entered for the above job requisition. Click the link below to view.

http://webserver:6001/servlets/iclientservlet/hp80/?ICType=Panel&menu=ROLE_MANAGER&market=GBL&panelGroupName=TW_POSITION_INFO&JOB_REQ_NBR=004130

New Position? N

Req Status: Open

Replaces: Blow,Joesph J

Position: Cust Service Rep 2 SD

Dept/Location: Call Center - San Diego Hub/San Diego - SW Market Area

Hiring Manager: Kreuger,Freddy J

Time Approver? N

New Work Space Needed? N

Work Space: Cube

New Computer Needed? Y

Type of Computer: Desktop - Single

PC Asset #

Monitor Asset #1:

Moniter Asset #2:

Data Jack #

New Phone Needed? Y

Type of Phone: Agent ACD

Ext:

Cell Phone: N

Pager: N

Blackberry: N

Palm: N

Calling Card: N

Parking Space: N

Send Fax: Y

Fax Browser: Y

CRIS: N

Green Screen: N

CTIOS: Y

DOES: N

FileNet: N

maxMC: Y

WRDA: Y

Other Software:

Comments:

Any help would be appreciated. Thanks!

October 28, 200520 yr

As long as the information collection points in the email are static (the list does change) then this is a tedious that doable routine. I've written a document parser that looks for specific items and then capture them into the appropriate fields. I created a parser script for each item, and then wrote a document parser script which runs each subscript to parse the document.

I've included an example of one the individual parser scripts.

#Clears parsing control fields

Clear [ Documents::parsing_pram1 ] [ Select ]

Clear [ Documents::parsing_pram2 ] [ Select ]

Clear [ Documents::parsing_pram3 ] [ Select ]

#Sets parsing control fields

Set Field [ Documents::parsing_pram1; Position ( Documents::parsing_text; "Server Name:"; 0; 1) ]

Set Field [ Documents::parsing_pram2; Position (Documents::parsing_text; ":"; Documents::parsing_pram1; 1) ]

Set Field [ Documents::parsing_pram3; Position ( Documents::parsing_text; "¶"; Documents::parsing_pram1; 1) ]

Set Field [ Servers::ServerName; Trim ( Middle (Documents::parsing_text; Documents::parsing_pram2+1; (Documents::parsing_pram3) - (Documents::parsing_pram2+1)) ) ]

HTH