03-21-2013
Above file "input.xls" definitely is neither EXCEL format - which is binary - nor CSV format. It's just a plain, space separated text file, as is "output.csv".
For chopping 5 first lines from text files, use e.g. awk 'NR>5' input.txt
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies
2. Shell Programming and Scripting
i have this file which has the following contents:
,-0.3000 ,-0.3000 ,-0.3000
,-0.9000 ,-0.9000 ,-0.9000
i would like to get this:
-0.3-0.9-0.3-0.9-0.3-0.9
so far i am trying:
awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2
any help... (4 Replies)
Discussion started by: npatwardhan
4 Replies
3. Shell Programming and Scripting
Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?
Thanks
Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies
4. Programming
hi all,
i have a select query that gives me the output in the following way...
SYSTYPE
--------------------------------------------------------------------------------
Success Failures Total RFT
---------- ---------- ---------- ----------
TYP
1 0 ... (3 Replies)
Discussion started by: sais
3 Replies
5. Shell Programming and Scripting
Hi ,
I have a simple text file with contents as below:
12345678900 971,76 4234560890
22345678900 5971,72 5234560990
32345678900 71,12 6234560190
the new csv-file should be like:
Column1;Column2;Column3;Column4;Column5
123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies
6. Shell Programming and Scripting
Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera (1 Reply)
Discussion started by: meerakrish
1 Replies
7. Shell Programming and Scripting
:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further..
Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like
file1 file2
00: 140 00: 235
01: 160 01:415... (1 Reply)
Discussion started by: mrudula
1 Replies
8. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
9. UNIX for Beginners Questions & Answers
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
10. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
LEARN ABOUT DEBIAN
tracertstats
TRACERTSTATS(1) User Commands TRACERTSTATS(1)
NAME
tracertstats - perform simple filter based analysis on a trace
SYNOPSIS
tracertstats [ -f | --filter bpf ] [ -i | --interval interval ] [ -c | --count count ] [ -o | --output-format csv,txt,png,html ] [ -m |
--merge-inputs ] inputuri...
tracertstats -H|--libtrace-help
DESCRPTION
tracertstats takes a list of bpf expressions and outputs the number of packets and bytes that match that expression every interval seconds,
or count packets.
-f bpf-filter
--filter bpf-filter
Add another "bpf filter"
-i interval
--interval interval
Output results every interval seconds.
-c count
--count count
Output results every count packets.
-m
--merge-inputs
Treats all inputs as a single input, resulting a single unified output rather than an output for each input. Works best with traces
that are consecutive to create a single CSV, for instance.
-o format
--output-format format
Selects the output format.
txt Human readable text. This is the default output format which provides output easily understood by a human. This format has
the disadvantage that it takes up quite a bit of horizontal space.
csv Comma Seperated Values. This is suitable for further analysis in a spreadsheet, or other program.
png PNG Graphic. Produces a fairly incomprehensible png graph. This relies on gdc being available at compile time.
html This produces output suitable for display to a human in a webbrowser.
EXAMPLES
tracertstats --filter 'host sundown'
--filter 'port http'
--filter 'port ftp or ftp-data'
--filter 'port smtp'
--filter 'tcp[tcpflags] & tcp-syn!=0'
--filter 'not ip'
--filter 'ether[0] & 1 == 1'
--filter 'icmp[icmptype] == icmp-unreach'
--output-format html
erf:/traces/trace1.gz
erf:/traces/trace2.gz
LINKS
More details about tracertstats (and libtrace) can be found at http://www.wand.net.nz/trac/libtrace/wiki/UserDocumentation
SEE ALSO
libtrace(3), tracemerge(1), tracesplit(1), tracesplit_dir(1), tracefilter(1), traceconvert(1), tracereport(1), tracepktdump(1),
traceanon(1), tracesummary(1), traceconvert(1), tracereplay(1), tracediff(1), traceends(1), tracetopends(1)
AUTHORS
Perry Lorier <perry@cs.waikato.ac.nz>
tracertstats (libtrace) November 2006 TRACERTSTATS(1)