get second value from string through query
Posted on 2012-08-28
i have a connected table (odbc), where tere are adresses stored, the layout is
debiteuren (space/hard return) address (space/hard return) postalcode city.
i need the address (postacode and city are in an other field as wel.
if i try right([adres];len([adres] -instrrev([adres;" ")) i get the value of the city
how can i extract the address, i think the problem is maybe because of the hard return and i'm selecting a space.
miss constance  stattionstraat 5 1121ad amsterdam
the result is amsterdam and i want stationstraat 5