Loop through a memo field, extract and past in new field

[RobPotts]

Hi,

I have a memo field Called PDRDetails in a TblDefects, this has loads of info I want to extract and put in there own individual fields onthe table. The memo text looks like:

Info, info, info
Initiator:= Mr Fred Bloggs
Job Role:= Dancer
Defect:= Small Apples
etc, etc

What I want is some code that looks through this text spots "Initiator:=", and gets the name, and pastes it into "Initiator" field on the table, then look up "job role:=" and copy it to its field in the Table, and so on through the list. Each bit of info is on a new line. The text to the left (Before the :=) will always be the same, but the bits I want to extract will change. Each bit of info required ":=" befor it. Is this possible and if so can you please help.

Thanks in advance
Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.

 

[RobPotts]

Hi All,

I've sorted this out now with some code MicaelRed posted in Tread181-113398

Thanks Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.