[AccessD] right clean after a specific character

[Gustav Brock]

Hi Kostas

I will. Thanks!

Happy New Year!
Gustav

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

HI Gustav, no, unfortunately the text is not something like consistent format mainly to the right part where its length depends on the length of the directors names, countries etc etc

Wow, The eastern part of Crete is nice, but I think you missed the best part, which is the western. If you ever decide to visit Crete again put the western part in your schedule and believe me you will be compensated to the max... and if you want send me an e-mail before do that -:😊

Thank's



-----Original Message-----
From: AccessD <accessd-bounces+kost36=gmail.com at databaseadvisors.com> On Behalf Of Gustav Brock via AccessD
Sent: Saturday, December 31, 2022 12:00 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] right clean after a specific character



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:  <mailto:kost36 at gmail.com%3cmailto:kost36 at gmail.com> 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> mailto:accessd at databaseadvisors.com><mailto:accessd at databaseadvisors.com%3e>

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

--