Memo field data extraction

[seat172]

Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES

1 CR10070SW £29.60 HALLITE PRODUCT
1 RBS24690 £0.82
1 RBS354 £0.95
2 RBS345 £0.75
1 S95MMEXT £3.90


£36.77 PER KIT

I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to. I can then extract them for upload into our system retaining the association with the parent part.

Thanks

 

[Moniker]

Have you looked at the SPLIT function? (Hint: Have it split on chr(13), which is a carriage return.)

 

[RuralGuy]

It is poor forum etiquette to post the same question in more than one forum.

 

[seat172]

Repeat posting

Sorry about that, having a bad day, by the time i realised it was too late. I do try to be polite at all times, it costs nothing but opens many doors as my mother used to tell me regularly.

 

[RuralGuy]

You are allowed to delete a thread *IF* you were the one that started it. It is an additional option when you edit the 1st post in a thread.