[AccessD] right clean after a specific character

[Gustav Brock]

Hi Kostas

If the format is somewhat consistent, you may get away with Split:

? Split(Split(YourText, "</td><td><b>")(1), "</b>")(0)
Movie title

/gustav

PS: I and Rita visited Crete in September, though we stayed a little North of Áyios Nikólaos. Having a car, we saw a lot of the Eastern part, but didn’t have the time to visit the Western part. Great experience and nice people - would love to return!

Fra: kost36 at gmail.com<mailto:kost36 at gmail.com>
Sendt: 31. december 2022 08:25
Til: 'Access Developers discussion and problem solving'<mailto:accessd at databaseadvisors.com>
Emne: [AccessD] right clean after a specific character

HI all,
In a field there are strings like
<table cellpadding="8"><tbody><tr><td><img src="./images/posters/1334.jpg"
width= "80" height="130"></td><td><b>Movie title</b><br><b>.....some other
characters
What I need is to get only the movie title
I use Mid$([title];113 for the left side but how to clean all the right
characters after the movie title?
Thank's
I wish a Happy New Year to all of you from Chania, Crete, Greece
/kostas konstantinidis