07-06-2011
Please post sample input file and desire output.
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. UNIX for Dummies Questions & Answers
Hi,
How can I create an excel file from a txt file using shell script. Please do a help for me.
Thanks,
Regards,
Milton (6 Replies)
Discussion started by: miltony
6 Replies
3. Shell Programming and Scripting
i want sort columns with headers based on another file headers
file1
eg: i'm having an empty file with only coumn names like
lastname firstname title expirydate stlcno status etc...
another file with same column names and some other as well but in different order...
file2
eg:firstname... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
5. Shell Programming and Scripting
Hi,
I am trying to attach and email a csv file in the form of an excel sheet.
And I have been successful in doing this.
But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet.
... (5 Replies)
Discussion started by: girish1428
5 Replies
6. Shell Programming and Scripting
Hi,
The result of a script is a csv file in the following format: cat $file_name
DATA_USAGE_FACT,YES_NO_FLG,TARGET_TABLE,YES_NO_FLG,1,0,15,0
DATA_USAGE_FACT,DATE_OF_CREATION,TARGET_TABLE,DATE_OF_CREATION,29,9,19,0
DATA_USAGE_FACT,UPDATION_DATE,TARGET_TABLE,UPDATION_DATE,29,9,19,0... (3 Replies)
Discussion started by: dips_ag
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Discussion started by: RamMore123
15 Replies
8. Shell Programming and Scripting
Hello friends
I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns
1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
6 Replies
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
I have to sort the 4th column of an excel/csv file. I tried the following command
sort -u --field-separator=, --numeric-sort -k 2 -n dinesh.csv > test.csv
But, it's not working. Moreover, I have to do the same for more than 30 excel/csv file. So please help me to do the same. (6 Replies)
Discussion started by: dineshkumarsrk
6 Replies
SRCONV(1) The Canonical Csound Reference SRCONV(1)
NAME
srconv - Converts the sample rate of an audio file. .
DESCRIPTION
Converts the sample rate of an audio file at sample rate Rin to a sample rate of Rout. Optionally the ratio (Rin / Rout) may be linearly
time-varying according to a set of (time, ratio) pairs in an auxiliary file.
SYNTAX
srconv [flags] infile
INITIALIZATION
Flags:
o -P num = pitch transposition ratio (srate / r) [don't specify both P and r]
o -P num = pitch transposition ratio (srate / r) [don't specify both P and r]
o -Q num =quality factor (1, 2, 3, or 4: default = 2)
o -i filnam = auxiliary breakpoints file (no breakpoint by default. i.e. No ratio change)
o -r num = output sample rate (must be specified)
o -o fnam = sound output filename
o -A = create an AIFF format output soundfile
o -J = create an IRCAM format output soundfile
o -W = create a WAV format output soundfile
o -h = no header on output soundfile
o -c = 8-bit signed_char sound samples
o -a = alaw sound samples
o -8 = 8-bit unsigned_char sound samples
o -u = ulaw sound samples
o -s = short_int sound samples
o -l = long_int sound samples
o -f = float sound samples
o -r N = orchestra srate override
o -K = Do not generate PEAK chunks
o -R = continually rewrite header while writing soundfile (WAV/AIFF)
o -H# = print a heartbeat style 1, 2 or 3 at each soundfile write
o -N = notify (ring the bell) when score or miditrack is done
o -- fnam = log output to file
This program performs arbitrary sample-rate conversion with high fidelity. The method is to step through the input at the desired sampling
increment, and to compute the output points as appropriately weighted averages of the surrounding input points. There are two cases to
consider:
1. sample rates are in a small-integer ratio - weights are obtained from table.
2. sample rates are in a large-integer ratio - weights are linearly interpolated from table.
Calculate increment: if decimating, then window is impulse response of low-pass filter with cutoff frequency at half of output sample rate;
if interpolating, then window is impulse response of lowpass filter with cutoff frequency at half of input sample rate.
CREDITS
Author: Mark Dolson
August 26, 1989
Author: John ffitch
December 30, 2000
AUTHORS
Barry Vercoe
MIT Media Lab
Author.
Dan Ellis
MIT Media Lab,
Cambridge
Massachussetts
Author.
COPYRIGHT
5.07 06/23/2009 SRCONV(1)