Sponsored Content
Top Forums Shell Programming and Scripting Arranging Haphazard output in readable format Post 302757819 by Visshal on Friday 18th of January 2013 04:18:20 AM
Old 01-18-2013
one way is you can run your sql query to get the output in csv format. Or you can run a script on this output replace | with , and open the file in excel or any spreadsheet. That way you can see output in tabular format.

Or just try following and open the file into spreadsheet.

Code:
me@lappy:~/Documents/file$ cat tmp.txt
123|456|789|0
67345123|3455|1
7124563|432343414|345324
me@lappy:~/Documents/file$ sed -e s/\|/,/g tmp.txt 
123,456,789,0
67345123,3455,1
7124563,432343414,345324

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

To convert multi format file to a readable ascii format

Hi I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source . Can any one suggest a way a logic to convert such... (5 Replies)
Discussion started by: gaur.deepti
5 Replies

2. HP-UX

file in malibox is readable format?

Hi, Files coming to mailbox are in readable format? Is there any special command to read these files. suppose i have sent a file like this megh$mailx -s "mesg" xyz@server.domain<file1.dat can xyz directly read the file from his mailbox? (1 Reply)
Discussion started by: megh
1 Replies

3. Shell Programming and Scripting

convert unix date to readable format

Dear Experts, I need your help to convert a unix date and time format number in to readable format like dd/mm/yyyy . I have a text file of more than 10,000 records and it is like NAME DATE1 COUNTRY DATE2 ABD 1223580395699 USA 1223580395699... (3 Replies)
Discussion started by: shary
3 Replies

4. UNIX for Dummies Questions & Answers

vmstat in a better readable format

Dear All: Is there a way to nicely format the vmstat output: #3sec interval, 5 measurements vmstat 3 5 It prints out all the good info but not in a very readable format. Any help, advise, suggestion will be highly appreciated. Thanks. (1 Reply)
Discussion started by: tom_k_mishra
1 Replies

5. UNIX for Dummies Questions & Answers

help in extracting logs in readable format

hello everyone. newbie here in unix. I am trying to extract the logs of a certain job and would like to output it in a readable format, see below the CAT part: cat /var/opt/ctma/ctm/sysout/idwesct_sh30_eng_r6_cdcs_sh.LOG_05l0du_000* | egrep -i 'orderid:|file_name=' | sed... (1 Reply)
Discussion started by: eanne_may
1 Replies

6. Shell Programming and Scripting

Need Help in arranging the output

Hello All, Please find attached input and output files. I want to write a shell script to achieve this. I tried using awk but not getting how to do this as I am new to shell programming. Thanks (4 Replies)
Discussion started by: Sudeep Bhattad
4 Replies

7. Shell Programming and Scripting

Multiple records need to convert UNIXtime to human readable datatime and all output in one format

Hello Experts, Below is the record i have: sample data attached I want this record of each row to be in single line and there are multiple rowise unixtime mentioned e.g 11996327 , This needs to be converted to Human readdable data and time from multiple rows Can you help me , it will be... (10 Replies)
Discussion started by: manishK
10 Replies

8. Shell Programming and Scripting

Arranging the output of a shell script into tables

Hi guys. I am new to this forum so cheers :) I have a question. I have created a shell script that puts all the output into 1 file. The out put is like this: -----IP------ Data Data Data -----IP------ Data Data Data How can i arrange this to be like this: IP | Data |... (3 Replies)
Discussion started by: Pandera
3 Replies

9. Shell Programming and Scripting

Arranging output for 2 commands

I am trying to run 2 sets of commands but want their output in a particular format. The 2 commands are : md5sum $WAR_DIR/$war and java -jar $WAR_DIR/$war | grep build.release.version | awk '{print $3}' The first command gives an output of 5f5261a33b92a36f80218cf14e8271ad ... (4 Replies)
Discussion started by: Junaid Subhani
4 Replies

10. Shell Programming and Scripting

Arranging the command output into an html table format

Hi, I need to format a command output for the beolow command: runmqckm -cert -list -db $MQ_KDB -pw $PASSWD -expiry $EXP | grep -v "Certificates in database" The output will be: "ABC - cert name" From: Tuesday, May 25, 1999 11:09:40 AM CDT To: Saturday, May 25, 2019 11:39:40 AM CDT ... (3 Replies)
Discussion started by: bdpl
3 Replies
ODFBUILD(1p)						User Contributed Perl Documentation					      ODFBUILD(1p)

NAME
odfbuild - OpenDocument file creation utility SYNOPSIS
odfbuild filename.odt odfbuild filename.odt --title "My Document" --subject "Test" odfbuild filename.ods --class spreadsheet --source "data.csv" --tablesize "8x16" cat data.txt | odfbuild filename.odt - OPTIONS
--class Document class (text, spreadsheet, drawing, presentation) Default: text --opendocument (no value). If this option is on, the document will be in OpenDocument format. Without this option, the format will be selected according to the general configuration of the OpenOffice::OODoc installation. --creator The author of the document. Default: the current user's login name. --date Creation date. Default is current local time. If provided, must be in ISO-8601 format (YYYY-MM-DDTHH:MM:SS) --description The description (abstract) of the document. Default: none. --force (no value). If this option is on, any existing file with the same path as the target file will be replaced. Without this option, the program will fail if the target exists. --generator Software signature to be stored in the file (not visible for the end user). Default: "Genicorp OpenOffice::OODoc <version>" --keywords A list of comma-separated keywords. Default: none. --source A text file, to be used as the content of the document. If the document class is 'text', each line is loaded as a new paragraph with the standard style. If the document class is 'spreadsheet', the file is processed as CSV data and loaded in one sheet. If the document class is neither 'text' nor 'spreadsheet', the file is not processed. If source = '-', or if a '-' argument is provided, the data file is read through the standard input. --subject The subject of the document. Default: none. --tablename The name of the sheet to be created if the document class is 'spreadsheet' and if a data file is provided. Default: the name of the data file, or "Unnamed Sheet" if the data is read from the standard input. --tablesize The size of the sheet to be created if the document class is 'spreadsheet' and if a data file is provided, in 'HxW' format where H is the number of lines and W the number of columns. Default: '16x8' --title The title of the document. Default: "Untitled". --readable_XML (no value). For debugging only. If this option is on, the XML content of the target file is indented, in order to be later edited. perl v5.14.2 2008-05-07 ODFBUILD(1p)
All times are GMT -4. The time now is 07:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy