Sponsored Content
Top Forums Shell Programming and Scripting Want to format column of a text file Post 302742313 by atul9806 on Tuesday 11th of December 2012 01:01:31 AM
Old 12-11-2012
Want to format column of a text file

Hi Techies
I have written a script which is collecting the logs of job running on server and let mail me the output.
I want to format column of output, please help.

Code:
CCMS_BAU_from_CACHE      RUN
ETL_SUBSITE_TO_SITE_BAU  RUN
GetClient_Prep_Main      RUN
MDM_Client_BAU   RUN
Sweeper  RUN
Staging_To_Reporting     RUNNING
Bridge_BAU       RUN
CMT_CUSTOMER_BAU RUN
CMT_CLIENT_HIERARCHY_BAU RUN
SAP_CUST_NI_CCMS RUN
CLIENT_DUNS_CUST_NI_CCMS RUN

as you can see Job status is not in a Column, I need them in a column
Please help


Thanks
Atul Singh

Last edited by Scrutinizer; 12-11-2012 at 03:55 AM.. Reason: Removed link
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Format a column of text

Hi I have a LONG ! column of text and I would like to format this into several columns. so from this abcd efgh ijkl mnop qrst uvwx yz12 to this abcd efgh ijkl mnop qrstu vwx yz12 (2 Replies)
Discussion started by: mlucas
2 Replies

2. Shell Programming and Scripting

How to print log file in column format using awk

Hi Friends, I have a log file as below siteid = HYD spc = 100 rset = RS_D_M siteid = DEL spc = 200 rset = RS_K_L siteid = DEL2 spc = 210 rset = RS_D_M Now I need a output like column wise as below. siteid SPC rset HYD 100 RS_D_M (2 Replies)
Discussion started by: suresh3566
2 Replies

3. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

4. Shell Programming and Scripting

Convert comma text file to Column in html format

I am trying to generate a report with below file : File1 : EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick EQADM,edrtere11-phys,8227caef0,gpatmon,/bin/ksh,nuten Erick EQADM,edrtere3-phys,822caef0,gpatmon,/bin/ksh,nuten Erick can you help me convert it to html and add... (9 Replies)
Discussion started by: sriram003
9 Replies

5. Shell Programming and Scripting

format text file

i have a text file in this format: name1^A1^B1^ name2^A2^B2^ ... namex^Ax^Bx^ name1^AA1^ name2^AA2^ ... namex^AAx^ name1^AAA1^BBB1^ name2^AAA1^BBB2^ ... namex^AAAx^BBBx^ name1^AAAA1^ name2^AAAA2^ ... namex^AAAAx^ i want to generate a file: (2 Replies)
Discussion started by: busystock
2 Replies

6. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

7. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

8. Shell Programming and Scripting

Convert the date format from mdy to ymd in column of file

The date format in the delimited file for one column '6/27/2011 12:00:00 AM' Is it possible o change it to '2011-06-27 12:00:00 AM' for all the records.. Thanks in advance..... (8 Replies)
Discussion started by: infernalhell
8 Replies

9. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

10. Shell Programming and Scripting

How to change the format of the date column in a flat file?

Hi, i have a flat file namely temp.txt with this data below ID|name|contact_date 101|Kay|2013-12-26 102|let|2013-12-26 I need to modify the date data in the flat file into MM/DD/YYYY HH24:MI:SS format let me know the code for this. Thank you! (5 Replies)
Discussion started by: srikanth_sagi
5 Replies
RUN-MAILCAP(1)                                                 Run Mailcap Programs                                                 RUN-MAILCAP(1)

NAME
run-mailcap, view, see, edit, compose, print - execute programs via entries in the mailcap file SYNOPSIS
run-mailcap --action=ACTION [--option[=value]] [MIME-TYPE:[ENCODING:]]FILE [...] The see, edit, compose and print versions are just aliases that default to the view, edit, compose, and print actions (respectively). DESCRIPTION
run-mailcap (or any of its aliases) will use the given action to process each mime-type/file in turn. Each file is specified as its mime- type, its encoding (e.g. compression), and filename together, separated by colons. If the mime-type is omitted, an attempt to determine the type is made by trying to match the file's extension with those in the mime.types files. If no mime-type is found, a last attempt will be done by running the file command, if available. If the encoding is omitted, it will also be determined from the file's extensions. Currently supported encodings are gzip (.gz), bzip2 (.bz2), xz (.xz), and compress (.Z). A filename of "-" can be used to mean "standard input", but then a mime-type must be specified. Both the user's files (~/.mailcap; ~/.mime.types) and the system files (/etc/mailcap; /etc/mime.types) are searched in turn for informa- tion. EXAMPLES see picture.jpg print output.ps.gz compose text/html:index.htm extract-mail-attachment msg.txt | see image/tiff:gzip:- OPTIONS All options are in the form --<opt>=<value>. --action=<action> Performs the specified action on the files. Valid actions are view, cat (uses only "copiousoutput" rules and sends output to STD- OUT) , compose, composetyped, edit and print. If no action is specified, the action will be determined by how the program was called. --debug Turns on extra information to find out what is happening. --nopager Ignores any "copiousoutput" directive and sends output to STDOUT. --norun Displays the found command without actually executing it. SECURITY
A temporary copy of the file is opened if the file name matches the Perl regular expresssion "[^[:alnum:],.:/@%^+=_-]", in order to protect from the injection of shell commands, and to make sure that the name can always be displayed in the current locale. In addition, the file is opened using its absolute path to prevent the injection of command-line arguments, for instance using file names starting with dashes. SEE ALSO
file(1) mailcap(5) mailcap.order(5) update-mime(8) AUTHOR
run-mailcap (and its aliases) was written by Brian White <bcwhite@pobox.com>. COPYRIGHT
run-mailcap (and its aliases) is in the public domain (the only true "free"). Debian Project 1st Jan 2008 RUN-MAILCAP(1)
All times are GMT -4. The time now is 06:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy