03-02-2011
Extract last cell of csv file
How do I extract the last cell in a column of a csv file using linux shell scripting?
Or alternatively, how do I get the number of cells of a csv file?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have one csv file and in that I want update particular cell. I know the row and coloumn number for that respective.
Please help me... (6 Replies)
Discussion started by: deepak_p86
6 Replies
2. Shell Programming and Scripting
Hi all I am new to unix . I need to write a script that extracts some data from oracle into a .csv file with heading of the columns in the file
SO i created the following two scripts but they are not working
ac.sql (this is the sql file that i will call inside the shell script when i run... (1 Reply)
Discussion started by: rajesh_tns
1 Replies
3. UNIX for Advanced & Expert Users
I need help to create a csv file with Unix command.
In csv file, i need to put two values in the same cell.
Rite now, whts happening is, if i put 2 values in the same cell, its comming as " asd, zxc" but i want it in different line but in same cell.
asd
zxc
Please reply me ASAP. (1 Reply)
Discussion started by: Prashant Jain
1 Replies
4. Shell Programming and Scripting
hi,
i have a situation where i have a csv file in the format
date,name
eg:
1284631889869,a
1284631889879,b
1284631889459,c
.
.
.
.
.
.
.
now i take a time and an interval from user. (5 Replies)
Discussion started by: niteesh_!7
5 Replies
5. UNIX for Dummies Questions & Answers
:confused:Hello -- i just joined the forums. I am a complete noob -- only about 1 week into learning how to program anything... and starting with linux.
I am working in Linux terminal.
I have a folder with a bunch of txt files. Each file has several lines of html code. I want to combine... (2 Replies)
Discussion started by: jetsetter
2 Replies
6. Shell Programming and Scripting
Hi,
I have a text like the one given below
status="Observation 1"
read1="Source rows not load"
read2="Score drop"
I want to create a csv and mail it out in such a way that all three lines will be in a single cell but as three lines.
For ex
Col C1
... (3 Replies)
Discussion started by: prasperl
3 Replies
7. UNIX for Advanced & Expert Users
how to extract data from single first cell and copy it notepad
sample source IN EXCEL
DD-MM-YYYY
LOANNUM LOANPARTID
OUTPUT IN NOTEPAD
DD-MM-YYYY
I WANT ALONE DATE SHOULD BE EXTRACTED FROM EXCEL AND COPY IT IN NOTEPAD
CAN ANYONE HELP REGARDING THIS USING SCRIPTS (2 Replies)
Discussion started by: gchandu
2 Replies
8. Shell Programming and Scripting
How can I delete a column from a CSV file which has comma separated value with a string enclosed in double quotes and a comma in between? I have a file 44.csv with 4 lines including the header like the below format:
column1, column2, column3, column 4, column5, column6
12,455,"string with... (6 Replies)
Discussion started by: dhruuv369
6 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I'm attempting to write the entire contents of a file to a specific .csv cell. So far have only a nawk one liner that will write a value into a specific .csv cell. Trying to use man page but can't seem to get any farther. Any help would be appreciated. nawk -v r=2 -v c=3 -v val=5 -F,... (7 Replies)
Discussion started by: jimmyf
7 Replies
10. Shell Programming and Scripting
Hi
How can I delete a columns from a CSV file which has comma separated value with a string enclosed in double quotes or square bracket and a comma in between?
I have a csv file with below format.
Template,Target Server,Target Component,Rule Group,Rule,Rule Reference Number,Rule... (7 Replies)
Discussion started by: Litu19
7 Replies
LEARN ABOUT DEBIAN
obd2csv
obd2csv(1) General Commands Manual obd2csv(1)
NAME
obd2csv - Convert obdgpslogger(1) logs to csv files
SYNOPSIS
obd2csv [ options ]
DESCRIPTION
Convert obdgpslogger(1) logs to csv files
OPTIONS
-o|--out <output filename>
Output to this .csv file
-d|--db <database>
Work from logs stored in this database file
-s|--start <time>
Only dump rows more recent than this
-e|--end <time>
Only dump rows older than this
-z|--gzip
gzip compress output using zlib [if available]
-v|--version
Print out version number and exit.
-h|--help
Print out help and exit.
NOT OPTIONS
These options aren't intended for end-users, they're for the GUI.
-p|--progress
Print out progress. It will occasionally print a number in the range [0..100], indicating progress percentage.
SEE ALSO
obdgpslogger(1), obd2kml(1), obd2gpx(1), obdsim(1), obdgui(1), obdlogrepair(1)
AUTHORS
Gary "Chunky Ks" Briggs <chunky@icculus.org>
obd2csv(1)