Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract text between 2 tags
Cell A1 contains the text below.
In Cell B1, how do extract all the text between <status and </status so it returns "error" another example, how do I extract all the text between <comment and </comment? generally, how do I extract text that lies between 2 tags? thanks a lot... <apple2 <statuserror</status <ack</ack <errortypeCan't enter BTC - Not currently short</errortype <comment<![CDATA[You can't enter an order to Buy To Close (BTC) because you do not have a short position in BHP. If you want to enter a BTC, make it conditional on a not-yet-executed STO order. ]]</comment </apple2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract text between 2 tags
I believe this will work:
=LEFT(MID(A2,FIND("<status",A2)+LEN("<status"),9 99),FIND("</status",MID(A2,FIND("<status",A2)+LEN("<status" ),999))-1) You can replace the "<status" & "</status" with other texts, if deisred, or simply change them to a cell reference. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SteveC" wrote: Cell A1 contains the text below. In Cell B1, how do extract all the text between <status and </status so it returns "error" another example, how do I extract all the text between <comment and </comment? generally, how do I extract text that lies between 2 tags? thanks a lot... <apple2 <statuserror</status <ack</ack <errortypeCan't enter BTC - Not currently short</errortype <comment<![CDATA[You can't enter an order to Buy To Close (BTC) because you do not have a short position in BHP. If you want to enter a BTC, make it conditional on a not-yet-executed STO order. ]]</comment </apple2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract text between 2 tags
thanks works great!
"Luke M" wrote: I believe this will work: =LEFT(MID(A2,FIND("<status",A2)+LEN("<status"),9 99),FIND("</status",MID(A2,FIND("<status",A2)+LEN("<status" ),999))-1) You can replace the "<status" & "</status" with other texts, if deisred, or simply change them to a cell reference. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SteveC" wrote: Cell A1 contains the text below. In Cell B1, how do extract all the text between <status and </status so it returns "error" another example, how do I extract all the text between <comment and </comment? generally, how do I extract text that lies between 2 tags? thanks a lot... <apple2 <statuserror</status <ack</ack <errortypeCan't enter BTC - Not currently short</errortype <comment<![CDATA[You can't enter an order to Buy To Close (BTC) because you do not have a short position in BHP. If you want to enter a BTC, make it conditional on a not-yet-executed STO order. ]]</comment </apple2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate html Tags from Excel formatted text | Excel Discussion (Misc queries) | |||
Need to extract certain text from text string | Excel Worksheet Functions | |||
Extract text from large Text | Excel Discussion (Misc queries) | |||
Text Extract | Excel Worksheet Functions | |||
EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions |