I need a little help of you. 

I have three table county which contains ID and country name
2nd table is State table which contain state id, state name country id
3rd table is city table city id, city name, state id and county id.

i have one master csv file of city table which contains name of country or 
state Example

city namestate name counry nameBangaloreKarnatakaIndiaKotaRajistanIndiaabc
karntakaIndiacdeabcUk




What  i want to split the master file into 3 parts(country, state and city) 
with auto generate ids

example

idcontry name                            idstatecontry ididcity namestate 
idcountry 
id1India1Karnataka11Bangalore112Uk2Rajaistan22Kota213abc33abc114cde32
can any one guide me .

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to