[AccessD] right clean after a specific character

[kost36 at gmail.com]

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>

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

--

AccessD mailing list

 <mailto:AccessD at databaseadvisors.com> AccessD at databaseadvisors.com

 <https://databaseadvisors.com/mailman/listinfo/accessd> https://databaseadvisors.com/mailman/listinfo/accessd

Website:  <http://www.databaseadvisors.com> http://www.databaseadvisors.com