When I download from the database the CSV file containing all summits, each field uses a comma (,) separator.
But, sometimes, there are also commas in the field “SummitName” such as for EA2/HU-089 = “San MartÃn, PeÃ±a de” and many others
It is a problem when we are trying to recover each field in a record.
But I don’t know how we could avoid the problem, unless to use another separator such as a semi colon (;).
And this may change lot of soft in the database…
Another solution is to ask to avoid commas in the field SummitName
Hello Alain - in some languages (or special routines) for a “explode”-commmand, “exploding” a csv record, you can define a “delimter”. I am sure your will find a solution for that problem in every programming language via google.
Thanks for your replies
I found another solution without using an “explode” command.
I look for commas in the csv line and search for a comma followed by a number (the first digit of the altitude of the summit).
Now it works, thanks again !