;
From: sqlite-users on behalf of
Bart Smissaert
Sent: Friday, December 6, 2019 11:59:06 PM
To: SQLite mailing list
Subject: Re: [sqlite] last occurrence of /*
I think it can be done.
Just dealing with the forward slash.
RBS
On Fri, Dec 6, 2019 at 11:49 PM Simon Slavin wrote
On 6 Dec 2019, at 11:59pm, Bart Smissaert wrote:
> I think it can be done.
> Just dealing with the forward slash.
Then use replace(X,Y,Z) to replace '/*' with something else before you do
whatever you were intending to do.
___
sqlite-users mailing
I think it can be done.
Just dealing with the forward slash.
RBS
On Fri, Dec 6, 2019 at 11:49 PM Simon Slavin wrote:
> On 6 Dec 2019, at 11:00pm, Bart Smissaert
> wrote:
>
> > How do I select the part of this statement starting with the last /* ?
>
> Not in SQLite. Do it in your code, or
I can do it in code. This is B4A on Android phone.
For that reason can't do UDF's or extensions.
This postcode thing was just a simple example, not to do with comment issue.
RBS
On Fri, Dec 6, 2019 at 11:48 PM Scott Robison
wrote:
> On Fri, Dec 6, 2019, 4:31 PM Bart Smissaert
> wrote:
>
> > I
On 6 Dec 2019, at 11:00pm, Bart Smissaert wrote:
> How do I select the part of this statement starting with the last /* ?
Not in SQLite. Do it in your code, or write your own function to do it and
load this function into SQLite.
___
sqlite-users
On Fri, Dec 6, 2019, 4:31 PM Bart Smissaert
wrote:
> I know I can do something like this:
>
> select replace(postcode, rtrim(postcode, replace(postcode, ' ', '')), '')
> from addresses
>
> which will get the part of the postcode starting with the space.
> Problem however is how to deal with the
I know I can do something like this:
select replace(postcode, rtrim(postcode, replace(postcode, ' ', '')), '')
from addresses
which will get the part of the postcode starting with the space.
Problem however is how to deal with the forward slash.
RBS
On Fri, Dec 6, 2019 at 11:09 PM Scott
On Fri, Dec 6, 2019, 4:00 PM Bart Smissaert
wrote:
> Have table with SQL statements and these statements may have comments,
> starting with /*
> How do I select the part of this statement starting with the last /* ?
> So if the statement is:
> select field1 /*comment 1 */ from table1 /*comment
8 matches
Mail list logo