Hi Linda,
I have checked the first csv-file on the website you mentioned. It seems a
normal file although not all the fields are filled with data. Hence probably
your impression of 'huges spaces' in between data?
It is a comma delimited csv file, this means that de fields (e.g. name,
address, town, etc) are seperated by commas and all information of one doctor
is put in one long line whereby the bits and pieces are seperated by comma's.
OpenOffice can seperate these lines into columns:
1. On your desktop you will find the OpenOffe icon.
2. Use File Explorer (I work on Windows) or similar for your operating system.
3. Drag the downloaded csv file and drop it on the OpenOffice icon.
4. OO will respond with a dialogbox in with you tick Comma under 'Seperated'
and remove any other ticks that may be there. The dialog will show you the
results allready. (Other csv files may use ; or tab as delimiter, which you
also find in the dialog).
5. Click OK. The file will be distributed over columns. The first line shows
the names of the fields, e.g. what data is presented in the column.
Now you can proceed to work with it as you are used to, using lists; e.g. sort,
search etc.
Good luck & kind regards from The Royalk Kingdom of The Netherlands.... ;-)))
Gerrit
On Thursday, 9 February 2023 at 07:26:31 CET, Linda Hull
<chalcedony6...@gmail.com> wrote:
This isn't a usual "I can't do x or y" problem. It might be an OO doesn't
open it right? I would like it if someone could help me make these files
readable. Barring that, I need some specific doctors. The data seems to be
all spread out in these .csv files. They ought to be lists of doctors,
including specialities and other information, so that one could find a
doctor. When I open the file: Active Provider Directory 20220902 (59.27
MB), I get a page with huge spaces and nobody seems to have entered the
data correctly. Am I wrong?
I would like to be able to find doctors by different parameters, such as
specialty and location.
'Find' works. 'Find all' does not, for me. The file is on this page:
https://dch.georgia.gov/providers/provider-directory
From:
https://dch.georgia.gov/how-do-i
It's the government, who knows what they intended to do?
They don't answer their phone.
Linda
