Notes tests, text files, manipulation of text files in Excel and with Excel VBA CSV stuff

[DocAElstein]

Notes in support of this post
http://www.eileenslounge.com/viewtop...325398#p325398
https://eileenslounge.com/viewtopic....325403#p325403
https://eileenslounge.com/viewtopic....325413#p325413

From here, http://www.eileenslounge.com/viewtop...325398#p325398 , the same link has been given twice
https://drive.google.com/drive/folders/1-ERBo_Rd66MfBztr1jMZuXWKqHYfF6fp?usp=sharing

https://drive.google.com/drive/folders/1-ERBo_Rd66MfBztr1jMZuXWKqHYfF6fp?usp=sharing

There are two files, pdf file , and a current offering of a text file

The text file is uploaded. Its original name from the OP was diabetes-27-apr-2017-to-23-april-2018.csv I have changed it to a .txt file

It is not a Comma Separated Values file. It has been converted somehow from a pdf file.
It appears to have a line separator of vbLf und separation of values is just by spaces.

The OP then gave access to all his files https://eileenslounge.com/viewtopic....325408#p325408 That zip file is uploaded here
I examined them and a few are comma separated files:
Yes = It is a comma separated value file
No = It is NOT a comma separated file
13-diabetes 27 apr 2017 to 23 april 2018.csv Yes
13-diabetes-27-apr-2017-to-23-april-2018.csv No
17-diabetes 27 apr 2017 to 23 april 2018.csv Yes
21-diabetes-27-apr-2017-to-23-april-2018.csv No
25-diabetes-27-apr-2017-to-23-april-2018.csv No
29-diabetes-27-apr-2017-to-23-april-2018.csv No
33-diabetes 27 apr 2017 to 23 april 2018_1.csv Yes (but there are many corruptions in it )
37-diabetes-27-apr-2017-to-23-april-2018.csv No
41-diabetes-27-apr-2017-to-23-april-2018.csv No
45-diabetes-27-apr-2017-to-23-april-2018 (1).csv No
45-diabetes-27-apr-2017-to-23-april-2018.csv No
5-diabetes-27-apr-2017-to-23-april-2018.csv No
5-diabetes-27-apr-2017-to-23-april-2018_1.csv No
9-diabetes 27 apr 2017 to 23 april 2018.csv Yes
9-diabetes-27-apr-2017-to-23-april-2018.csv No
diabetes 27 apr 2017 to 23 april 2018.pdf pdf file
diabetes-27-apr-2017-to-23-april-2018.csv No
I have looked extensively manually into diabetes-27-apr-2017-to-23-april-2018.csv. The formatting is a bit inconsistent, and also a bit quirky, it looks different in different text editors:
https://i.postimg.cc/ZqXVPmCS/Differ...in11-Vista.jpg






_.________________________________________________ ______________________________
Excel Files from pdf attempt:- https://app.box.com/s/ywwjzsk168pbdbf7r8twastu52cdhaaf
Share ‘diabetes 27 apr 2017 to 23 april 2018.doc’ https://app.box.com/s/7w7xtmj4owlbs3tttga38xroom1q2gtf
Share ‘diabetes 27 apr 2017 to 23 april 2018.pdf’ https://app.box.com/s/5xby7eoay85p4vxk3xi4ai8dfpi0qivs
Share ‘diabetes-27-apr-2017-to-23-april-2018 from OP google drive Feb 22 saved as Excel file.xls’ https://app.box.com/s/9997gjd7qfqr9jq8716u53gsnlh0ev13
Share ‘diabetes-27-apr-2017-to-23-april-2018 from OP google drive Feb 22.txt’ https://app.box.com/s/csuc5x7m0b4d8b9nbkzx0m4e9n6y1fr7
Share ‘diabetes-27-apr-2017-to-23-april-2018 with vbCr & vbLf.txt’ https://app.box.com/s/mu43fiicp3fxdmea7q6bq346wecstm68