01-12-2014
Dear DON and Akshay,
Thanks for your help, this will definitely ease my work.
Best regards,
Amit
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent.
E.g : username empid
------------------------
sri 123
to
username,empid
sri,123
Thanks,
Hema:confused: (2 Replies)
Discussion started by: Hemamalini
2 Replies
2. UNIX for Dummies Questions & Answers
I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know.
Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ?
Thanks in advance.
Floyd (3 Replies)
Discussion started by: fwellers
3 Replies
3. Shell Programming and Scripting
Hi,
I have the following text file:
8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm
9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm
10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm
11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies
4. Shell Programming and Scripting
please help me writing a awk script
001_r.pdb 0.0265185
001_r.pdb 0.0437049
001_r.pdb 0.0240642
001_r.pdb 0.0310264
001_r.pdb 0.0200482
001_r.pdb 0.0146746
001_r.pdb 0.0351344
001_r.pdb 0.0347856
001_r.pdb 0.036119
001_r.pdb 1.49
002_r.pdb 0.0281011
002_r.pdb 0.0319908
002_r.pdb... (5 Replies)
Discussion started by: phoenix_nebula
5 Replies
5. Shell Programming and Scripting
Hi,
I have two text files. Need to create a third text file extracting specific data from first two existing files..
Text File 1: Format contains:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Aug 4 21:06:34 2010
some text ............so on...and somwhere text like:
Record 1:... (1 Reply)
Discussion started by: shashi143ibm
1 Replies
6. Shell Programming and Scripting
Hi All,
I need to convert an exel spreadsheet into a SAS dataset,
and the following format change is needed. Please help, this is too complex
for a biologist.
Let me describe the input.
1st row is generation.1st column in keyword 'generation', starting 2nd column there are 5... (9 Replies)
Discussion started by: newbie83
9 Replies
7. Shell Programming and Scripting
"Help Me" Need script for transferring bulk files from one format to text format in a unix server.
Please suggest (2 Replies)
Discussion started by: Kranthi Kumar
2 Replies
8. Shell Programming and Scripting
i have installed CENTOS in VMware. I want the linux command to run in CENTOS.
The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script.
Thanks,
Shobana (1 Reply)
Discussion started by: shobana praveen
1 Replies
9. Shell Programming and Scripting
Hi Team,
I have created a script to output DB Query data to a text file. It displays output as follows for 2 different queries appended to same file.
I want help to convert this data to xls format so that the output of first query is in 1 tab and the other in second tab. Please help.
... (14 Replies)
Discussion started by: srkmish
14 Replies
10. UNIX for Advanced & Expert Users
Hi All,
Am needing advise on how to convert xls file to xlsx format on Solaris unix command line or scripting. I tried searching online but it looks like I need to either use Perl packages of Excel or Python packages or some other 3rd party tool. Problem is to install any of these will require... (2 Replies)
Discussion started by: arvindshukla81
2 Replies
LEARN ABOUT DEBIAN
audiolink
AUDIOLINK(1) User Contributed Perl Documentation AUDIOLINK(1)
NAME
audiolink - Create AudioLink config file, databases and tables
SYNOPSIS
audiolink [OPTION]...
DESCRIPTION
AudioLink is a set of programs which help you manage your music collection. It makes searching for music on your local storage media easier
and faster. Your searches can include a variety of criteria, like male artists, female artists, band, genre, etc.
It supports music files of MP3 and Ogg Vorbis formats.
audiolink assists you in creating a configuration file for oft-used options passed to the AudioLink programs and creating the MySQL
database and tables which the AudioLink programs, alfilldb(1) and alsearch(1) use.
The options specified on the command prompt override the options specified in the config file.
OPTIONS
--help
Brief usage information
--host=xxx
Connects to the MySQL server on the target host. Default is localhost.
--pass=xxx
Password for the database
--user=xxx
Username for the database
--verbose
Display extra information about what's going on
MORE INFORMATION
The user and password fields for the database have to be specified. There are three ways of doing this:
1. Command-line arguments
By specifying them via the --user and --pass command-line arguments to the programs:
"alfilldb --user=mysql_username --pass=mysql_password --prompt=basic /songs/"
"alsearch --user=mysql_username --pass=mysql_password --artist=kishore --td=/songs/kishore"
2. Environment variables
Setting the DBI_USER and DBI_PASS environment variables:
If you are using bash, ksh, zsh or sh do this:
"export DBI_USER=mysql_username"
"export DBI_PASS=mysql_password"
If you are using csh or tcsh, do this:
"setenv DBI_USER mysql_username"
"setenv DBI_USER mysql_password"
Consult the man page of the respective shell interpreter that you use for help on environment variables.
3. Config file
Specifying them in the config file (the most convenient). The config file is stored in each user's home directory in the
~/.audiolink/config location.
CONFIGURATION FILE
The AudioLink configuration file config resides in the .audiolink/ directory in the user's home directory ($HOME/.audiolink/config).
The format of the current config file is pretty easy to understand: Just put in "a = b" on separate lines for all the options you want the
AudioLink scripts to use by default. Here, a is the option name, like user, password, host, etc., and b is the value you wish to associate
the option with. For example, to set the username for accessing the database to 'root', you would put this in the config file:
"user = root"
SEE ALSO
L<alfilldb(1)>, L<alsearch(1)> The current version of this man page is available on the AudioLink website at
<http://audiolink.sourceforge.net/>.
BUGS
Report bugs related to the AudioLink software or the man pages to the audiolink-devel mailing list <audiolink-devel@lists.sourceforge.net>.
AUTHOR
This manual page is written and maintained by Amit Shah <amitshah@gmx.net>
COPYRIGHT
The AudioLink package is Copyright (C) 2003, Amit Shah <amitshah@gmx.net>. All the programs and the documentation that come as part of
AudioLink are licensed by the GNU General Public License v2 (GPLv2).
perl v5.14.2 2012-04-09 AUDIOLINK(1)