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 columns. On 16/06/2011, at 2:19 PM, Simon Slavin wrote: > How many different first words are there ? Is it just 'North' and 'South' ? > Maybe the two other directions too ? Or are there hundreds of them ? 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't completely populate lookup tables before I bring in the Import. There will be a new Import periodically which might contain new Silo Groups and Regions, and I won't be able to manually add those to the lookup tables before importing. Ideas? Thanks, Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases develo...@barefeetware.com -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
