Extract Portion of Text Strings into separate columns

[okinawan79]

Hi Everyone,



I have below texts in one cell (column)

Descriptions:
abcedfgeljkfjldsjflkjf

Pre-Conditions:
akjdfljdskfsjdl


Post-Conditions:
kjljkjk

Next Test(s):
sdfdsfds



I want to extract Pre-Conditions and Post-Conditions on to a separate columns using query design...

help!
Thank you

[June7]

Show example real data.

What is actual data structure? Is there consistency in length of each part or separated by space or character?

[orange]

Welcome.
You may know what the question means, but readers do not.
I suggest you try again with real data and clearly show the before and after data.
Clarity is key to asking a question and getting a focused response.

[okinawan79]

I have attached the screenshot from what it look like in Excel. Once imported into Access, I would like

"Pre-Conditions: 1. Cash Receipt is Created in CSA " in new column and

"Post-Conditions: 8300 tables are updated with the information edited in this case" in new column
for 1st row

[okinawan79]

Show example real data.

What is actual data structure? Is there consistency in length of each part or separated by space or character?

Posted the reply with picture... hope this helps.

Thanks again for your help

[June7]

Consistency of structure is critical when parsing strings. Let x represent the TS_DESCRIPTION field and consider:

Mid(x, Instr(x,"Descriptions:"), Instr(x,"Pre-")-3)

Mid(x, Instr(x,"Pre-Conditions:"), Instr(x,"Post-")-Instr(x,"Pre-Conditions:")-2)

Mid(x, Instr(x,"Post-Conditions:"), Instr(x,"NextTest(s):")-Instr(x,"Post-Conditions:")-2)

Mid(x, Instr(x,"NextTest(s):"))

If this doesn't satisfy requirement, likely have to do a VBA custom function.