Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: need awk or sed help to reformat output
Top Forums Shell Programming and Scripting need awk or sed help to reformat output Post 302670485 by ux4me on Thursday 12th of July 2012 06:20:28 AM
Old 07-12-2012
need awk or sed help to reformat output
We have the following output:

Code:
server1_J00_data_20120711122243
server1_J00_igs_20120711122243
server1_J00_j2ee_20120711122243
server1_J00_sec_20120711122243
server1_J00_data_20120711131819
server1_J00_igs_20120711131819
server1_J00_j2ee_20120711131819
server2_J00_data_20120711122245
server2_J00_igs_20120711122245
server2_J00_j2ee_20120711122245
server2_J00_sec_20120711122245
server2_J00_data_20120711131821
server2_J00_igs_20120711131821
server2_J00_j2ee_20120711131821
server2_J00_sec_20120711131821

Instead of using array programming, is there a simpler solution using awk or sed to reformat the above output to this:

Code:
20120711122243
          server1_J00_data
          server1_J00_igs
          server1_J00_j2ee
          server1_J00_sec

20120711122245
          server2_J00_data
          server2_J00_igs
          server2_J00_j2ee
          server2_J00_sec

20120711131819
          server1_J00_data
          server1_J00_igs
          server1_J00_j2ee

20120711131821
          server2_J00_data
          server2_J00_igs
          server2_J00_j2ee
          server2_J00_sec

Please advise and thanking you in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

reformat date, awk and sed

The command below is getting me the output I need. awk -F"," ' { if ($6 = 475) print "@@"$3 " " "0000" $10 "0" $1 "00000000" $8}' ${DIR1}${TMPFILE1} | sed -e 's/@@1//g' > ${DIR2}${TPRFILE} Output: 900018732 00004961160200805160000000073719 Now I need to incorporate... (5 Replies)
Discussion started by: mondrar
5 Replies

2. UNIX for Advanced & Expert Users

reformat ps output

I often use "ps -ef" command to list all running processes. Now i want to customize the output to show only 2 parts: CMD and UID as below: /bin/bash /usr/bin/run-parts /etc/cron.weekly root /usr/sbin/httpd apache /usr/sbin/httpd apache /usr/sbin/httpd apache I use ps -ef | awk '{print $8"... (3 Replies)
Discussion started by: fongthai
3 Replies

3. UNIX for Advanced & Expert Users

Script to reformat output

Hi colleagues, I have the followind script. db2 -x "select substr(TBSPACE,1,20) TABLESPACE from syscat.tables where tabschema = 'SCHEMA' and tabname like '%XXXX' group by TBSPACE order by TBSPACE" | awk '{print $1}' | while read tablespace do db2 "list tablespaces show detail" |grep -p -w... (5 Replies)
Discussion started by: systemoper
5 Replies

4. Shell Programming and Scripting

awk to reformat text

I have this input and want output like below, how can I achieve that through awk: Input: CAT1 FRY-01 CAT1 FRY-04 CAT1 DRY-03 CAT1 FRY-02 CAT1 DRY-04 CAT2 FRY-03 CAT2 FRY-02 CAT2 DRY-01 FAT3 DRY-12 FAT3 FRY-06 Output: category CAT1 item FRY-01 (7 Replies)
Discussion started by: aydj
7 Replies

5. Shell Programming and Scripting

awk reformat file

Hello: When I tried a perl-oneliner to re-format fasta file. infile.fasta >YAL069W-1.334 Putative promoter CCACACCACACCCACACACC ACACCACACCCACACACACA ACAGCCCTAATCTAACCC >YAL068C-7235.2170 Putative ABC sequence TACGAGAATAATTT ACGTAAATGAAGTT TATATATAAA >gi|31044174|gb|AY143560.1|... (15 Replies)
Discussion started by: yifangt
15 Replies

6. Shell Programming and Scripting

Use search pattern to reformat the output

I have below file listing ] ls -1 *.txt MISTradesReport_141105_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt MISTradesReport_141106_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt MISTradesReport_141107_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-24.txt... (4 Replies)
Discussion started by: krg.sati
4 Replies

7. Shell Programming and Scripting

Using awk to reformat file output

Hi there. I need to reformat a large file. Here is a sample of the file. NETIK0102_UCS_Boot_a,NETIK0102_UCS_Boot_b 5200 2438 70G 5200 2439 70G NETIK0102_UCS_HBA0_a,NETIK0102_UCS_HBA1_b,NETIK0102_UCS_HBA2_a,NETIK0102_UCS_HBA3_b 2673 19D7 55G 2673 19C0 30G 2673 19F5 120G... (5 Replies)
Discussion started by: kieranfoley
5 Replies

8. Shell Programming and Scripting

Alter awk script to reformat output

Data: 0,mfrh_green_screen,1455432969,37540,/prod/test/system/sys/unikixmain.log,3.0M,mfrh_green_screen,3120660,0,36964--37540 0,mfrh_green_screen,1455433269,38100,/prod/test/system/sys/unikixmain.log,3.1M,mfrh_green_screen,3164223,0,37540--38100... (1 Reply)
Discussion started by: SkySmart
1 Replies

9. Shell Programming and Scripting

Reformat awk output

I need to rearrange the output but i am unable to arrange it to match the format. In the output i need NAME=\"To in the column . Bash: #!/bin/bash cd /cygdrive/c/output/a cat *.txt > output.txt i=/cygdrive/c/output/a/output.csv #echo "NE_Name, Source, Destination, OSPF_AREA_ID"... (4 Replies)
Discussion started by: adgjmpt
4 Replies

10. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies

LEARN ABOUT OPENSOLARIS

xdg-user-dir

xdg-user-dir(1) 						   User Commands						   xdg-user-dir(1)

NAME

       xdg-user-dir - Get the path used for desktop user directory location.

SYNOPSIS

       xdg-user-dir DIR

DESCRIPTION

       xdg-user-dir is a utility that extracts the location of the specified desktop user directory from the file :

	   ${HOME}/.config/user-dirs.dirs

OPERANDS

       Valid desktop directories (DIR) are:

	       DESKTOP
	       DOWNLOAD
	       TEMPLATES
	       PUBLICSHARE
	       DOCUMENTS
	       MUSIC
	       PICTURES
	       VIDEOS

       If an invalid directory is requested ${HOME} is returned.

ENVIRONMENT VARIABLES

       See environ(5) for descriptions of the following environment variables:

	   HOME.

       Other environment variable that are used are:

       XDG_CONFIG_HOME

	   Base directory for storge of XDG configuration files. Defaults to ${HOME}/.config

FILES

       The following files are used by this application:

       /usr/bin/xdg-user-dir

	   XDG Directory expansion utility.

       ${XDG_CONFIG_HOME}/user-dirs.dirs

	   Location of the user-specific configuration including the current list of directories and what they map to.

EXAMPLES

       Example 1: Location of user's documents directory

       % xdg-user-dir DOCUMENTS

       /home/user/Documents

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWxdg-user-dirs 	   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Uncommitted		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       More information can be found at:

       http://www.freedesktop.org/wiki/Software/xdg-user-dirs

       xdg-user-dirs-update(1), xdg-user-dirs-gtk-update(1), attributes(5)

NOTES

       Written by Darren Kenny, Sun Microsystems Inc, 2008

SunOS 5.11							    03 Apr 2008 						   xdg-user-dir(1)
All times are GMT -4. The time now is 07:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy