Re: [sqlite] Breaking a string into two

2011-06-27 Thread BareFeetWare
> 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

Re: [sqlite] Breaking a string into two

2011-06-16 Thread Igor Tandetnik
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

Re: [sqlite] Breaking a string into two

2011-06-16 Thread Simon Slavin
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

Re: [sqlite] Breaking a string into two

2011-06-15 Thread Michael Stephenson
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

Re: [sqlite] Breaking a string into two

2011-06-15 Thread BareFeetWare
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

Re: [sqlite] Breaking a string into two

2011-06-15 Thread Simon Slavin
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

[sqlite] Breaking a string into two

2011-06-15 Thread BareFeetWare
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