Extract first line from a description field
Posted: 2009-06-19 13:44:13
In the past I used the DESCRIPTION field to collect "Languages", "Country" and "Description". The data was stored in this field with the HTML tag I need. Now I organize the catalog in a different way and I need to move "Languages" and "Country" from this field to another, leaving the DESCRIPTION field with only original "Description" data.
My DESCRIPTION field looks like this:
Does anybody know how can be done this?
My DESCRIPTION field looks like this:
First line have a variable length, but always end with CR/LF followed by the "<h3>Description: </h3>" and can be easily extracted, but I don't know the script functions/procedures that can do it.<h3>Languages: </h3>English <h3>Country: </h3>USA
<h3>Description:</h3>Lorem ipsum dolor...
Does anybody know how can be done this?