Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Change file format
Top Forums Shell Programming and Scripting Change file format Post 302172803 by jim mcnamara on Tuesday 4th of March 2008 04:28:04 PM
Old 03-04-2008
input
Quote:
Statistics Report - 2008/02/07
---------------------------------------------------
process SFA Success
ctr1 <= 120
ctr2 <= 1785
ctr3 <= 2616
ctr4 <= 50958
ctr5 <= 9148
ctr6 <= 3718992
ctr7 <= 1567
ctr8 <= 203
ctr9 <= 455
ctr10 <= 199460
Process SFA Fail
ctr1 <= 40
ctr2 <= 624
ctr3 <= 74
ctr4 <= 11
ctr5 <= 2
ctr6 <= 1732
ctr7 <= 21747
Process MTA Success
ctr1 => 63780
ctr2 => 63669
ctr3 => 135
ctr4 => 1674
ctr5 => 8274
ctr5 => 1772
Process MTA Fail
ctr1 => 5
ctr2 => 14
ctr3 => 10
ctr4 => 5096
ctr5 => 810
ctr6 => 1847
output
Quote:
csadev:/home/jmcnama> cat SFA_Fail
ctr1 40
ctr2 624
ctr3 74
ctr4 11
ctr5 2
ctr6 1732
ctr7 21747
csadev:/home/jmcnama> cat SFA_Success
ctr1 120
ctr2 1785
ctr3 2616
ctr4 50958
ctr5 9148
ctr6 3718992
ctr7 1567
ctr8 203
ctr9 455
ctr10 199460
csadev:/home/jmcnama> cat MTA_Success
ctr1 63780
ctr2 63669
ctr3 135
ctr4 1674
ctr5 8274
ctr5 1772
csadev:/home/jmcnama> cat MTA_Fail
ctr1 5
ctr2 14
ctr3 10
ctr4 5096
ctr5 810
ctr6 1847
Code:
awk 'BEGIN {getline;getline;}
 {
 if ($0 ~/SFA Success/) { header="SFA_Success"; continue}
 if ($0 ~/SFA Fail/   ) { header="SFA_Fail"; continue}
 if ($0 ~/MTA Success/) { header="MTA_Success"; continue}
 if ($0 ~/MTA Fail/   ) { header="MTA_Fail"; continue}

 if(header=="SFA_Success") {print $1, $3 > "SFA_Success"}
 if(header=="SFA_Fail"   ) {print $1, $3 > "SFA_Fail"   }
 if(header=="MTA_Success") {print $1, $3 > "MTA_Success" }
 if(header=="MTA_Fail"   ) {print $1, $3 > "MTA_Fail"   }                         
 }' filename

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Change format to file II

hi all... i have a big problem, and i hope someone can help me... i have a flat file, and its columns are separated by comma (CSV), something like this: 78 , 204R180 , 90/100 , 200001 , 12 ,200002 ,13 ..... 78 , 204R180 , 90/100 , 200001 , 29 ,200002 ,30 ..... 78 , 204R180 , 90/100 ,... (0 Replies)
Discussion started by: DebianJ
0 Replies

2. Shell Programming and Scripting

To Change the file format Pls Help!!!

Hi All, I have a file like john::208:johnson john::208:mery john::208:test admin:*:1:johnson admin:*:1:test and wanna convert this as john::208:johnson,mery,test admin:*:1:johnson,test please help me to create a script for this thanks in advance John (4 Replies)
Discussion started by: johnsonpk
4 Replies

3. Shell Programming and Scripting

How to change date format in file

Hello! I have a textfile that look like this: "83d1:46:2b";"20091008190000";"Rögle BK - Skellefteå";"Swedish" "d4c:46:21";"20091008190000";"Södertälje - Brynäs";"Swedish" "d4b:46:2";"20091008190000";"HV 71 - Färjestad";"Swedish" "838:46:b";"20091010160000";"Skellefteå - HV 71";"Swedish"... (2 Replies)
Discussion started by: condmaster
2 Replies

4. Shell Programming and Scripting

Change file output format

I have a file which has following contents usmtnz-dinfsi19 62 61 18400 18800 99.7 usmtnz-dinfsi19 62 61 18400 18800 99.7 i want the o/p to be like date (7 Replies)
Discussion started by: fugitive
7 Replies

5. Shell Programming and Scripting

howto change format of file?

Hi I have a file with this inside: How can I change it to: thanks a lot regards Israel. (3 Replies)
Discussion started by: iga3725
3 Replies

6. Shell Programming and Scripting

File date format how to change

Hi All, Below are the unix files taken by the help of ls -lrt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 13:33 sand.txt -rw-r--r-- 1 kbehera Domain Users 4 Jul 27 13:37 sand1.txt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 15:30 new_sand.txt -rw-r--r-- 1 kbehera Domain Users 0 Jul 27... (2 Replies)
Discussion started by: krupasindhu18
2 Replies

7. Shell Programming and Scripting

Change the file format

gpio_rw = gpiochip162 audio_aplay = HDMI_0 audio_aplay = HDMI_1 audio_aplay = HDMI_2 graphic_xrandr_show = USB1 graphic_xrandr_show = USB2 graphic_xrandr_show = USB3 graphic_change_resolution = eDP1 gpio_rw = "gpiochip162" audio_aplay = "HDMI_0 HDMI_1 HDMI_2" graphic_xrandr_show =... (3 Replies)
Discussion started by: yanglei_fage
3 Replies

8. Shell Programming and Scripting

Date format change in a csv file

Hi, We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script. Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies

9. Shell Programming and Scripting

Shell script change new format on the file.

Hi---Is there's way can write small shell script or perl script open "abc.txt" file and create new "new_abc.txt" file with format output below? Thanks cat abc.txt ###########################Readme############################### Contained with this README.TXT file are all of the file... (7 Replies)
Discussion started by: dotran
7 Replies

10. UNIX for Beginners Questions & Answers

Change date format in a file.

Hi all, I have a file as below, i would like the change the format of the time from "11/7/2019 20:12" to "2019-07-11 20:12:00" in the last coloumn. any awk solution on this. Input: 2,0,695016,1961612,497212,5800804,0,0,161,33,7605,12226,23,10,66,0,0,34,11/7/2019 20:10... (4 Replies)
Discussion started by: Raghuram717
4 Replies

LEARN ABOUT DEBIAN

dwww-format-man

DWWW-FORMAT-MAN(8)						      Debian							DWWW-FORMAT-MAN(8)

NAME

       dwww-format-man - batch format manual pages for dwww

SYNOPSIS

       dwww-format-man [-v|--verbose] directory ...

DESCRIPTION

       dwww-format-man	looks  for manual pages in the directories named on the command line.  It formats each manual page, and puts the formatted
       version into the dwww document cache.  System administrator's can run dwww-format-man if they want to make it  faster  to  retrieve  manual
       pages  via  dwww.   If  dwww-format-man	is  not  run, dwww will automatically format manual pages not in its cache.  Long pages take a few
       moments to format, but rarely so slow that it is worth running.

       dwww-format-man runs dwww-convert(8) with privileges of DWWW_CGIUSER (see dwww(7).

OPTIONS

       -v, --verbose
	      Print each proceeded file name.

SEE ALSO

       dwww(7), dwww-convert(8).

AUTHOR

       Lars Wirzenius <liw@iki.fi>.  Slightly modified by Robert Luberda <robert@debian.org>.
       See dwww(7) for copyrights and stuff.

dwww 1.11.1							February 15th, 2009						DWWW-FORMAT-MAN(8)
All times are GMT -4. The time now is 12:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy