[AccessD] clear x characters...
stuart at lexacorp.com.pg
Thu Feb 13 21:50:55 CST 2020
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
> AccessD mailing list
> AccessD at databaseadvisors.com
> Website: http://www.databaseadvisors.com
More information about the AccessD