CSV file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers CSV file
# 8  
Old 02-11-2008
Tools So, what about the data

The datafiles are somewhere, and they have a name. (Sometimes the name can tell a little about the type of file and how it is written.)

Does the software tell you at a menu or someplace where your data is and the filenames? Otherwise, you are going to have to hunt through this.

You should have access to commands such as:
dir or ls -- either will give a directory listing
cd -- this is how you move around, as in cd newdirectory

How familiar are you with unix commands?
Is the computer connected to the internet in any way - to move files and/or allow remote access?
# 9  
Old 02-11-2008
csv

I've used this unix system for 2 yrs. I know a few old dbase commands. have found directory but scroll lock doesn't work for that computer & can't get directory to print. dir I use is usr2/meddata. I need the patient demographics info.
# 10  
Old 02-12-2008
Tools directory to print...

ls -l >flist.txt

redirects the output to a file
then

cat flist.txt

that way, you can see the files
from there, to print

lp flist.txt

assuming that you have a default printer specified
# 11  
Old 02-12-2008
csv

doesn't work. Says not found.
# 12  
Old 02-12-2008
what is not found?

cat flist.txt

does not work?

what happens if you ls flist.txt -- the file should be there

Also, I private messaged you so that we may take this conversation off-line. Check your PM's. (Top right area of these screens)
# 13  
Old 04-10-2008
Bug Medical Manager CSV file export

Medical Manager (through V9) uses a fixed length CSV text based internal file format. The patient demographics are stored in the "PATFILE.dat". This file, "patfile.dat" can be copied (must use a copy or you will destroy the Medical Manager Database). The "patfile.dat" file should be renamed to "patfile.csv". Using excel you can directly import the file. Just double click on it. If over 65K records then use ACCESS or any program that can import CSV files. After that it is simple to export the patient data. It is text, just delete the columns that uyou do not want to export then export in CSV format. The file is in CSV format internally. Example:
"LastName","FirstName",12345,...,...., LF. just "space padded on the right" to fixed length as shown.
Good luck!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

2. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

3. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

4. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

5. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

6. Shell Programming and Scripting

Comparing 2 CSV files and sending the difference to a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 ... (1 Reply)
Discussion started by: Naresh101
1 Replies

7. Shell Programming and Scripting

Reading from a CSV and writing in same CSV file

Hi, I am tryng to read from a csv file and based on some grep command output I will modify one of the column in the same csv. Example:- Input CSV:- 20120829001415,noneAA,google.com 20120829001415,dfsafds,google.com 20120829001415,noneAA,google.com Intermediate Step:- If 2nd column of... (3 Replies)
Discussion started by: kmajumder
3 Replies

8. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies

9. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
Login or Register to Ask a Question