0

Osgeo.ogr seems not able to correctly get the field name of a csv file. Take this example:

Identifian,C,254;CodeVoieRi,C,254;CodeInseeI,N,10,0
1;;13021
2;;13021
3;;13021

The problem is that ogr take the "," and the ";" as delimiters while the "," are just part of the column name.

Here is the python code i use:

dataSource = ogr.Open(file)
daLayer = dataSource.GetLayer(0)
layerDefinition = daLayer.GetLayerDefn()
for i in range(layerDefinition.GetFieldCount()):
     name = layerDefinition.GetFieldDefn(i).GetName()

Is it possible to specify to ogr to use a single delimiter?

Thanks!

Jbertrand
  • 419
  • 1
  • 4
  • 14

1 Answers1

0

I would suggest to never use commas in field names as it will often create conflicts when trying to parse a file. Using underscores _ instead would be a better method to name fields.

If your goal is to create a shapefile from this CSV file, you can look at this example to see how you can parse correctly your file using a specificied delimiter and convert the data to a shapefile.

https://pcjericks.github.io/py-gdalogr-cookbook/vector_layers.html#create-a-new-shapefile-and-add-data

kaycee
  • 901
  • 1
  • 9
  • 35
  • The goal was just to save the field name in DB. I'll try with the basic python csv reader, it seems it can take a delimiter as parameters. – Jbertrand Dec 23 '16 at 08:21