03-15-2012
Hi,
I prepared script and i am sending output put to csv file which is excel. So whenever lq property is blank next field xmitq is coming into lq property. So what i want is whenever lq is blank it should print ",". That is why i am using "," in awk. So it will separate the value and keep it in next coloumn. CSV(Comma separated value)
Last edited by darling; 03-15-2012 at 12:23 PM..
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :
079661/3
I have to convert the above series as
079661
079662
079663
and store it as 3 different records.
Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
Discussion started by: mihirk
10 Replies
2. UNIX for Advanced & Expert Users
i have a report.csv file from oracle datavase
In that file data is like this with report heading and date
SALES DAILY REPORT
DATE: 06-26-2007
REPORT NAME: SALES DATA
AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END
ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Discussion started by: raosurya
3 Replies
3. Shell Programming and Scripting
Hi Scripting gurus,
I need to convert following text snippet into csv. please help
Input
heading1 = data1
heading2 = data2
..
..
heading n = data n
heading 1 = data1
..
..
Output
data1,data2,....,data n (3 Replies)
Discussion started by: azs0309
3 Replies
4. Shell Programming and Scripting
thanks for allowing me join your forum
i have an output of linux command "who"
which provides following details.....
CURRENT USER/ACCT INFO
17:31:36 up 4:49, 4 users, load average: 0.03, 0.04, 0.00
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root :0 - 12:59 ?xdm? 4:54 0.02s /bin/sh /usr/bi... (1 Reply)
Discussion started by: ayyappancheta
1 Replies
5. UNIX for Dummies Questions & Answers
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
Discussion started by: Grhyll
4 Replies
6. Shell Programming and Scripting
Hello All,
I have a csv file that looks like below
ProdId_A,3.3.3,some text,some/text,sometext_1.2.3
ProdId_B,3.3.3,some text,some/text,sometext_1.2.3
ProdId_C,3.3.3,some text,some/text,sometext_1.2.3
ProdId_A,6.6.6,some text,some/text,sometext_9.9.9
I will get ProdId from... (5 Replies)
Discussion started by: anand.shah
5 Replies
7. Shell Programming and Scripting
Hi All,
I am trying to create a CSV file within a shell script test.ksh and the code snippet is something like below:
#!/usr/bin/ksh
# Set required variables.
. $HOME/.prof
# Output file path
Group1=/tmp/G1.csv
Group2=/tmp/G2.csv
Group3=/tmp/G3.csv
$ORACLE_HOME/bin/sqlplus -s... (2 Replies)
Discussion started by: swasid
2 Replies
8. Programming
hi all,
i attach a csv file of what im trying to explain
basically i get iMacro (like an excel macro that you can record and play back recordings but its for web browsers) to download csv reports of the printer(s)
when you open the csv report it contains certain cells -
D7 - black... (5 Replies)
Discussion started by: robertkwild
5 Replies
9. UNIX for Beginners Questions & Answers
I need to fetch below values from this file. (1 Reply)
Discussion started by: nit42
1 Replies
LEARN ABOUT CENTOS
pppoe-setup
PPPOE-SETUP(8) System Manager's Manual PPPOE-SETUP(8)
NAME
pppoe-setup - Shell script to configure Roaring Penguin PPPoE client
SYNOPSIS
pppoe-setup
DESCRIPTION
pppoe-setup is a shell script which prompts you for various pieces of information and sets up an /etc/sysconfig/network-scripts/ifcfg-ppp0
configuration script for the pppoe-start, pppoe-stop and +pppoe-connect scripts.
AUTHOR
pppoe-setup was written by David F. Skoll <dfs@roaringpenguin.com>.
The pppoe home page is http://www.roaringpenguin.com/pppoe/.
SEE ALSO
pppoe(8), pppoe-start(8), pppoe-stop(8), pppoe-connect(8), pppd(8), pppoe.conf(5), pppoe-status(8), pppoe-sniff(8), pppoe-relay(8), pppoe-
server(8)
4th Berkeley Distribution 21 February 2000 PPPOE-SETUP(8)