Example:
How can I get the first cell value?
Asked
Active
Viewed 53 times
-1
-
1Use a CSV reading library. – Andy Turner Sep 06 '16 at 21:55
-
is "heelloe,goil" wrapped in quotes? – holtc Sep 06 '16 at 21:56
-
Reopened. This question is not a request for a CSV API, although the answer might be. – user207421 Sep 06 '16 at 23:08
-
@holtc no its not wrapped with quotes – Prabhu Sep 07 '16 at 19:07
-
then it's not a properly formatted csv, as @EJP has said – holtc Sep 07 '16 at 20:07
-
@holtc I tried even having those strings within quotes, but no luck. – Prabhu Sep 07 '16 at 20:24
-
'No luck' is not a problem description. – user207421 Sep 08 '16 at 20:27
1 Answers
0
If the cell with the internal comma isn't enclosed in quotes, it has been improperly written, and you can't read the file properly at all.
You don't really need a CSV library for this: it 's easy enough to write a CSV reader, but you have to know the convention. Any cell can be enclosed in quotes, which take priority over any internal commas, and which should be removed.
user207421
- 305,947
- 44
- 307
- 483