[AccessD] clear x characters...

[Stuart McLachlan]

Aircode, but it should be close:

Title = Mid$(strData,14, Instr(strData,"<br>") -14)
Director = Mid$(instr(strData,"<br>" + 5),instr(strData,"(") - instr(strData,"<br>" + 5))
ProdCountries = Mid$(Instr(strData,"(") , Instr(strdata(")") - Instr(strData,"(") )

 

On 12 Feb 2020 at 18:29, Kostas Konstantinidis wrote:

> Dear people
> I import a lot of records from a mysql table which are like:
> <font size=1>ANGRY BIRDS  2<br> Thurop Van Orman, John Rice (USA,
> Finland)<br>5/9/2019 - Spentzos Film</font> <font size=1> THE
> FAVORITE<br>Giorgos Lanthimos (USA, UK, Irland )<br>5/9/2019 -
> Feelgood Ent</font> etc...
> 
> What I need is to split it in three different fields (columns)
> 
> 1. to keep only the Movie Title clearing the first 14 standard
> characters and everything after the end of the title e.g.
>     ANGRY BIRDS  2
>     THE FAVORITE
> 2. to keep only the director´s name (after the first "<br> " and
> everything after the first "(" e.g.
>     Thurop Van Orman, John Rice
>     Giorgos Lanthimos
> 3. to keep only the Production Countries (including into parenthesis)
> clearing all the previous and after that characters
> 
> is that possible from msaccess query?
> 
> Many thank´s
> /kostas
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com