Sponsored Content
Top Forums Shell Programming and Scripting Shell script for CSV conversion Post 302481785 by ayyappancheta on Sunday 19th of December 2010 11:53:48 PM
Old 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

shell script conversion to binary

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

Help me with file conversion [Shell Script]

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

Need timestamp conversion shell script !!

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

Conversion of below Tabs Tex file into CSV format file : shell script needed

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

Conversion batch shell script

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

Shell script for .Txt to .csv conversion with data processing

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

Batch to shell script conversion

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

powershell script to unix shell script conversion.

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

Shell script ouput conversion

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
uptime(1)						      General Commands Manual							 uptime(1)

NAME
uptime, w - show how long system has been up and/or who is logged in and what they are doing SYNOPSIS
[user] [pset_list]] [user] [pset_list]] DESCRIPTION
prints the current time, the length of time the system has been up, the number of users logged on to the system, and the average number of jobs in the run queue over the last 1, 5, and 15 minutes for the active processors. is linked to and prints the same output as displaying a summary of the current activity on the system. Options and recognize the following options: Print the current time, the length of time the system has been up, and the number of users logged on to the system in the first line of the output. The average number of jobs in the core over the last 1, 5, and 15 minutes for the active processors is also printed. When used with the option, the load averages for the processor sets (psets) are calculated on a core basis. Suppress the first line and the heading line. This option should not be used with the option. This option assumes the use of the option to Use long output. This option assumes the use of the option to Print the current time, the length of time the system has been up, and the number of users logged on to the system in the first line of the output. The load averages over the last 1, 5, and 15 minutes for the processor sets (psets) given in the command line, pset_list, are displayed in the subsequent lines. If no arguments are given, the load averages are displayed for all the psets in the system. If pset id of an empty pset is given in the command line, a corresponding message will be displayed. If the kernel does not have the pset capability, gives an error. The option cannot be used along with other options except Use the short form of output for displaying terminal information. The terminal name is abbreviated, and the login time and CPU times are suppressed. Print only the first line describing the overall state of the system. This is the default for the command. Print a summary of the current activity on the system for each user. This is the default for the command. EXAMPLES
The command: produces text resembling the following: depending upon the current status of the system. The command: gives the load average of all the psets in the system. If 0, 94, 95, and 97 are existing psets in the system, the output will look like the following: The command: gives output which looks like the following if 94 and 95 are valid pset ids: The command: gives the load average of the system, producing output resembling the following: The command: gives the load average of all the psets in the system. If 0 and 1 are psets in the system, the output will look like the following: AUTHOR
was developed by the University of California, Berkeley and HP. SEE ALSO
mpctl(2), pset_ctl(2). uptime(1)
All times are GMT -4. The time now is 06:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy