12-20-2010
Shell script for CSV conversion
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
root pts/0 :0 12:59 4:31m 0.00s 1:20 kded [kdeinit]
root pts/1 :0.0 16:18 1.00s 0.00s 0.00s -bash
root pts/2 :0.0 16:25 49.00s 0.02s 0.00s bash
This output i saved into a file named WHO.log
Now how to covert this output into CSV format so that i can export it into some database-------
using some bash script!!!!!!!!!!!!!!!!
any suggestion in this regard is greatly appreciated
thanks in advance
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
My question is:
i have a script called getevent
to run i just call ./getevent
can i convert this to make it binary executable and not letting my clients open it and see the code.??:(
I am using Solaris 8. (3 Replies)
Discussion started by: bcheaib
3 Replies
2. Shell Programming and Scripting
Hello Group,
I request your help with a shell script for filter an ascii file (this is small piece of the file):
09/24/2009,00:00,1.0268,1.0268,1.0249,1.0250,518
09/24/2009,01:00,1.0251,1.0261,1.0249,1.0259,424
09/24/2009,02:00,1.0258,1.0272,1.0258,1.0269,372... (3 Replies)
Discussion started by: csierra
3 Replies
3. AIX
Can anyone provide me with a ksh or bash script which will accept a timestamp (format is YYYY-MM-DD-HH24.Mi.Ss) and time offset (in hours). The output will be (timestamp passed - time offset passed deducted from it) in the same YYYY-MM-DD-HH24.Mi.Ss format.
Basically I am trying to convert the... (1 Reply)
Discussion started by: shibajighosh
1 Replies
4. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies
5. Shell Programming and Scripting
while converting batch file to shell script ...dis command is ther i dunno how to change...can anyone knws how to change into shell script
rm !(D:\temp\XX.txt) (3 Replies)
Discussion started by: monisha
3 Replies
6. Shell Programming and Scripting
Hi experts,
I want to convert a txt file having rows and columns (CNAI_DUMP_raw.txt) by comparing it with another text file (paramaters.txt) and generate a output in CSV which contains only 3rd column from CNAI_DUMP_raw.txt, and the columns mentioned in parameters.txt.
FYI: There are two... (16 Replies)
Discussion started by: Gautam Banerjee
16 Replies
7. Shell Programming and Scripting
Hi All,
I have a small tool which is currently configured in batch scripts only. But my need is to run it on Linux platform, so I have been trying to convert a batch script to shell script.
below is the batch script:
@echo off
IF "%1"== "" GOTO ARGERR
REM UPDATE THESE PROPERTIES TO... (2 Replies)
Discussion started by: sukhdip
2 Replies
8. UNIX for Beginners Questions & Answers
Here is a powershell script to use restful API to create ticket in our ticketing tool. Can anyone please convert it to a shell script sothat, I can run it in Unix servers,
below is the code:
$body = @{
Customer= ''test'
Summary= 'test summary'
Impact= '4-Minor/Localized'
... (2 Replies)
Discussion started by: pandeybhavesh18
2 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
I am trying to print all the packages info in solaris 11 using below script.
#!/usr/bin/env bash
pkginfo -l | egrep '(BASEDIR|NAME|VERSION)' | awk '{print}' > /tmp/cp1
/usr/bin/nawk -F: '
{for (i=1; i<=NF; i++) {gsub (/^ *| *$/, "", $i)
... (5 Replies)
Discussion started by: sravani25
5 Replies
LEARN ABOUT DEBIAN
lr_environment
LR_ENVIRONMENT.IN(1) LogReport's Lire Documentation LR_ENVIRONMENT.IN(1)
NAME
lr_environment - Export Lire configuration in shell script form
SYNOPSIS
eval `lr_environment`
DESCRIPTION
The lr_environment command is used to import the Lire configuration in Lire shell scripts.
All of Lire configuration variables will be written in a format that can be evaled by the shell.
Shell scripts don't usually have to use that command, since it is done by the defaults file sourced by each command.
The old names used by when the configuration was done in shell script are also exported by this script for backward compatibility.
AUTHOR
Francis J. Lacoste <flacoste@logreport.org>
VERSION
$Id: lr_environment.in,v 1.12 2006/07/23 13:16:33 vanbaal Exp $
COPYRIGHT
Copyright (C) 2003 Stichting LogReport Foundation LogReport@LogReport.org
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
Lire 2.1.1 2006-07-23 LR_ENVIRONMENT.IN(1)