Hi Han,
when reading the AAVSO report file into programs that accept a comma as delimiter problems arise as the notes column also contains commas:
,(Local database V05, aperture=1.7 HFD, annulus=4 HFD)
A solution would be to chose a different delimiter in this column as compared to the delimiter for the columns. e.g. comma as column delimiter and semicolon within column text:
,(Local database V05; aperture=1.7 HFD; annulus=4 HFD)
cs Axel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Han,
when reading the AAVSO report file into programs that accept a comma as delimiter problems arise as the notes column also contains commas:
,(Local database V05, aperture=1.7 HFD, annulus=4 HFD)
A solution would be to chose a different delimiter in this column as compared to the delimiter for the columns. e.g. comma as column delimiter and semicolon within column text:
,(Local database V05; aperture=1.7 HFD; annulus=4 HFD)
cs Axel
Thanks for the feedback. Yes I have changed it in the code. If the delimiter is a comma then it will use in the comments the semicolon else the comma.
cs Han