Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Dear Friends
I have text file as like below,
AAAAA|BHBHBH|VERYSMART
AAAAA| KKKKKK|GOOD
BBBBBB|JJJJJJJ|VERYGOOD
CCCCC|HJHJHJ|BETTER
CCCCC|UUUUU|GOOD
i need to split into seperate files based on column 1 like as below
AAAAA.TXT contains
--------------------
BHBHBH.VERYSMART... (4 Replies)
:confused: Hi UNIX gurus,
I am facing a typical problem while assigining while assigining output of awk to a variable.
I have a fixed length file say myinputfile.txt
When I allow the value/output of an awk to be redirected to a file, it works fine. i.e.
awk "/^.{232}$acctNum/ {... (8 Replies)
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname... (4 Replies)
Dear All,
we have a command output which looks like :
Total 200 queues in 30000 Kbytes
and we're going to get "200" and "30000" for further process. currently, i'm using :
numA=echo $OUTPUT | awk '{print $2}'
numB=echo $OUTPUT | awk '{print $5}'
my question is : can I use just one... (4 Replies)
How can I assign a variable to an variable. IE $car=honda
One way I can do it is export $car=honda
or
let $car=2323
Is there any other ways to preform this task (3 Replies)
I have a log file that has certain fields that I want to evaluate, and depending on the value in those fields, I want to put the value of a different field in that line in a particular variable that I'll use later on down the log file. Sort of like setting a switch to change what I do with a bunch... (5 Replies)
I launch 'netstat -a', if string 'ESTABLISHED' found, then VAR=1
#!/bin/bash
VAR=0;
netstat -a | awk '$6 ~ /ESTABLISHED/ {VAR=1}'
I cannot find the right syntax.
thanx guys! (3 Replies)
Hi Gurus,
I have a script which assign awk output to shell variable. current it uses two awk command to assign value to two variables. I want to use one command to assign two values to two variables. I tried the code, but it does't work. kindly provide your suggestion.
current code... (2 Replies)
Discussion started by: green_k
2 Replies
LEARN ABOUT DEBIAN
audio::mpd::common::item::song
Audio::MPD::Common::Item::Song(3pm) User Contributed Perl Documentation Audio::MPD::Common::Item::Song(3pm)NAME
Audio::MPD::Common::Item::Song - a song object with some audio tags
VERSION
version 1.120881
DESCRIPTION
Audio::MPD::Common::Item::Song is more a placeholder with some attributes. Those attributes are taken from the song tags, so some of them
can be empty depending on the file.
The constructor should only be called by Audio::MPD::Common::Item's constructor.
ATTRIBUTES
album
Album of the song. (format code: %d)
artist
Artist of the song. (format code: %a)
albumartist
Artist of the album. (format code: %A)
composer
Song composer. (format code: %C)
date
Last modification date of the song. (format code: %M)
disc
Disc number of the album. This is a string to allow tags such as "1/2". (format code: %D)
file
Path to the song. Only attribute which will always be defined. (format code: %f)
genre
Genre of the song. (format code: %g)
id
Id of the song in MPD's database. (format code: %i)
last_modified
Last time the song was modified. (format code: %m)
name
Name of the song (for http streams). (format code: %N)
performer
Song performer. (format code: %P)
pos
Position of the song in the playlist. (format code: %p)
title
Title of the song. (format code: %t)
track
Track number of the song. (format code: %n)
time
Length of the song in seconds. (format code: %l)
METHODS
as_string
my $str = $song->as_string( [$format] );
Return a string representing $song. If $format is specified, use it to format the string. Otherwise, the string returned will be:
either "album = track = artist = title"
or "artist = title"
or "title"
or "file"
(in this order), depending on the existing tags of the song. The last possibility always exist of course, since it's a path.
This method is also used to automatically stringify the $song.
WARNING: the format codes are not yet definitive and may be subject to change!
AUTHOR
Jerome Quelin
COPYRIGHT AND LICENSE
This software is copyright (c) 2007 by Jerome Quelin.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-04-01 Audio::MPD::Common::Item::Song(3pm)