> BareFeetWare wrote:
>> I have some source data that includes a "Silo And Region" column of two
>> words appended together, such as 'NorthPlains',
>> 'SouthPlains', 'NorthSlopes', 'SouthSlopes' etc. I want to split them into
>> two columns.
>>
>> How can I do this in SQLite? A regex or offset
BareFeetWare wrote:
> I have some source data that includes a "Silo And Region" column of two words
> appended together, such as 'NorthPlains',
> 'SouthPlains', 'NorthSlopes', 'SouthSlopes' etc. I want to split them into
> two columns.
>
> How can I do this in SQLite? A regex or offset/positio
On 16 Jun 2011, at 5:27am, BareFeetWare wrote:
> There could be dozens of each but the main issue is that I don't know what
> they are until I get the data. That's what I meant by:
>
>>> I don't know all of the parts (ie "Silo Group" and "Region") until I bring
>>> in the Import.
>
> So I can
le
if you're interested in going this route.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of BareFeetWare
Sent: Thursday, June 16, 2011 12:06 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Breaking a string in
Hi Simon,
Thanks for the reply.
> On 16 Jun 2011, at 5:05am, BareFeetWare wrote:
>
>> I have some source data that includes a "Silo And Region" column of two
>> words appended together, such as 'NorthPlains', 'SouthPlains',
>> 'NorthSlopes', 'SouthSlopes' etc. I want to split them into two col
On 16 Jun 2011, at 5:05am, BareFeetWare wrote:
> I have some source data that includes a "Silo And Region" column of two words
> appended together, such as 'NorthPlains', 'SouthPlains', 'NorthSlopes',
> 'SouthSlopes' etc. I want to split them into two columns.
How many different first words ar
Hi all,
I have some source data that includes a "Silo And Region" column of two words
appended together, such as 'NorthPlains', 'SouthPlains', 'NorthSlopes',
'SouthSlopes' etc. I want to split them into two columns.
How can I do this in SQLite? A regex or offset/position and replace function
w
7 matches
Mail list logo