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

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

And are you really using version 7?

Edited February 15, 201016 yr by Guest

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

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.

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