| View previous topic :: View next topic |
| Author |
Message |
slabo
General User
Joined: 27 Jul 2010
Posts: 5
|
 Posted: Tue Jul 27, 2010 5:01 am Post subject: [solved]extract <img src="alphanumeric string.jpg /& |
 |
|
Hi,
I want to extract | Quote: | <img src="0a0eee796e4b81106935241d7b51d60c.jpg" />
|
into column B and | Quote: | | [sound:8e3ea08f826a28f4a9efa7d661a8471d.mp3] |
into column C from | Quote: | <img src="0a0eee796e4b81106935241d7b51d60c.jpg" /><br />What's this?[sound:8e3ea08f826a28f4a9efa7d661a8471d.mp3]
|
for all the cells in column A . The rest should go to column D.
I looked at regular expressions, but syntax is different for OpenOffice and i could use some help.
Any help appreciated,
Thanks.
Last edited by slabo on Tue Jul 27, 2010 7:23 pm; edited 1 time in total |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
Location: Sydney, Australia
|
| Posted: Tue Jul 27, 2010 5:57 am Post subject: |
|
|
If A1 has...
| Code: | | <img src="0a0eee796e4b81106935241d7b51d60c.jpg" /><br />What's this?[sound:8e3ea08f826a28f4a9efa7d661a8471d.mp3] |
then | Code: | | =LEFT(A1;FIND(">";A1)) |
returns | Code: | | <img src="0a0eee796e4b81106935241d7b51d60c.jpg" /> |
and | Code: | | =MID(A1;FIND("[";A1);255) |
returns | Code: | | [sound:8e3ea08f826a28f4a9efa7d661a8471d.mp3] |
If the first formula is in B1 and the second formula is in C1 then | Code: | =SUBSTITUTE(SUBSTITUTE(A1;B1;"");C1;"")
|
returns
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
slabo
General User
Joined: 27 Jul 2010
Posts: 5
|
| Posted: Tue Jul 27, 2010 7:21 pm Post subject: |
|
|
Thanks for the quick reply.
Works, no need for regular expressions. |
|
| Back to top |
|
|
|
