1st you have to tell which fields/columns should be used, like for example using the semicolon as delimiter:
Then someone here in the forum would be able to write a short awk/sed line to make your file a csv-File. What you showed is no csv file, it's just some lines where nothing is really separated by an unique delimeter.
When you got a delimeter then ie. a "real" csv-File, you can import it to Excel and the columns will be recognized by defining the right delimeter.
Hi need some advice..
#grep -i hostname test.csv
(gives the below output)
HOSTNAME,name,host_test,,,,,,,,
Now I need to format the above output as below.
HOSTNAME:
name=host_test
Any easy way of doing this using awk or sed or printf? (4 Replies)
I am using find and ls to search for "warez" files on my server.
find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh
This command produces this:
-rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3
I want to only get this
3.2M... (4 Replies)
I have input file in this way
John 1234 BASIC 26000
John 1234 ALLOWC 01550
John 1234 INCER 01700
John 1234 REL 20000
Debi 2345 BASIC 29000
Debi 2345 ALLOWC 01600
Debi 2345 INCR 01900
Debi 2345 REL ... (8 Replies)
Hi Guys
I need help removing some lines from output i am receiving from a shell script.
Here is the output:
http://i52.tinypic.com/10z0fut.png
I am trying to remove the output that i have circled.
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf
... (7 Replies)
Hey can anyone help me with newline formatting?
i bet someone will ask why im rewriting du code, im trying to write a simple script that have slightly different function than du lol....
echo $(du "$dval" | tr ' ' '\n')
atm with above code it will printout
i've tried sed and awk... cant... (7 Replies)
I am using FORTRAN 90 on AIX 5.3 and need to output my data to a tab-delimited file. It must have actual tabs, and I cannot figure out a way to make it work. The resulting file will be imported into another application (quickbooks) as an .iif file....for some reason, it needs the tabs; spaces do... (2 Replies)
I have the output like below:
DEV#: 9 DEVICE NAME: hdisk9 TYPE: 1750500 ALGORITHM: Load Balance
SERIAL: 68173531021
==========================================================================
Path# Adapter/Path Name State Mode Select Errors
0 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
LEARN ABOUT DEBIAN
ifpps
ifpps(8) netsniff-ng-toolkit ifpps(8)NAME
ifpps - fetch and format kernel network statistics
SYNOPSIS
ifpps -d|--dev <netdev> [-t|--interval <sec>][-p|--promisc][-c|--term]
[-C|--csv][-H|--csv-tablehead][-l|--loop][-v|--version][-h|--help]
DESCRIPTION
A tiny tool to provide top-like reliable networking statistics. ifpps reads out the 'real' kernel statistics, so it does not give
erroneous statistics on high I/O load.
OPTIONS
ifpps --dev eth0
Fetch eth0 interface statistics.
ifpps --dev eth0 --interval 60 --csv
Output eth0 interface statistics every minute in CSV format.
OPTIONS
-h|--help
Print help text and lists all options.
-v|--version
Print version.
-d|--dev <netdev>
Device to fetch statistics for i.e., eth0.
-p|--promisc
Put the device in promiscuous mode
-t|--interval <time>
Refresh time in sec (default 1 sec)
-c|--term
Output to terminal
-C|--csv
Output in CSV format. E.g. post-processing with Gnuplot et al.
-H|--csv-tablehead
Print CSV table head.
-l|--loop
Loop terminal output.
AUTHOR
Written by Daniel Borkmann <daniel@netsniff-ng.org>
DOCUMENTATION
Documentation by Emmanuel Roullit <emmanuel@netsniff-ng.org>
BUGS
Please report bugs to <bugs@netsniff-ng.org>
2012-06-29 ifpps(8)