Trente

...this was my first POST... Sorry about my bad english!

Hi LaRetta and Comment! Many thanks to you both! I am very grateful for the solution you two put together. This was my first record (but definitely not the last ...) and I never thought that my problem would be solved so quickly!

Absolutely spiffing! The demo you attached works perfectly! Many thanks Comment! And thanks for answering LaRetta, but the the gold medal goes to Comment this time...

Hi. I have a similar problem. Have tried to modify the attached demon, but I can not get it to work. I want to extract "Quantity" which is always between the 1st and 2nd "|" and "id" which is always between the 4th and 5th "|". The text field is this: Item_name1|Quantity1|Price1|Tax1|Id1|Item_name2|Quantity2|Price2|Tax2|Id2|Item_name3|Quantity3|Price3|Tax3|Id3| Thanks in advance!