Simple concept, difficult calculation (for me at least)

[321]

Hello all,

I want to separate the data below (which comes from one text field) into ten separate fields within the same record. For instance, "Status" is a field and "Received" would populate it. "Date/Time" is a field and "2/12/2010 4:33:07 PM" would populate it. etc, etc. Any ideas from the text parsing wizards out there would be appreciated. :

Thanks, Eric

Status: Received

Date/Time: 2/12/2010 4:33:07 PM

Speed: 14400 bps

Connection time: 00:36

Pages: 1

Resolution: Normal

Remote ID: 18885551212

Line number: 1

DTMF/DID: 1

Description: Fax received from 18885551212

[comment]

Will there always be the same 10 lines, in the same order?

And are you really using version 7?

Edited February 15, 2010 by Guest

[321]

Yes, same ten lines in same order on each record.... and I am using 7. I know, a little old school.

[comment]

This will extract the text "Normal" from the 6th line of the text:

Let ( [

t = MiddleValues ( text ; 6 ; 1 ) ; 

start = Position ( t ; ": " ; 1 ; 1 ) + 2 ;

end = Position ( t ; ¶ ; 1 ; 1 ) 

] ;

Middle ( t ; start ;  end - start )

)

To extract the other values, just change the 6 to the desired line number.

[321]

Worked like a charm. Thanks for the assistance. Very much appreciated.