To: firebird-support@yahoogroups.com
Subject: [EXT] Re: [firebird-support] Help with splitting a string in Firebird
SQL
Simple,
replace(reverse(substring(reverse(i.location) from position(' ',
reverse(i.location, ' / - ', ' AT ' )
Though splitting on the last space would be a problem
Simple,
replace(reverse(substring(reverse(i.location) from position(' ',
reverse(i.location, ' / - ', ' AT ' )
Though splitting on the last space would be a problem with cities having
spaces in their names, e.g. New York (USA) or St Albans (England).
HTH,
Set
ons. 9. okt. 2019 kl. 00:14
Hello All,
I could use some help/direction with splitting (or extracting data between
certain characters in) an existing string. This is generally a simple task in
code using IndexOf, LastIndexOf, etc. but I can't seem to figure out the syntax
in Firebird SQL (and it has to be done in SQL