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 CENTOS

fmtdump

FMTDUMP(8)							     [nmh-1.5]								FMTDUMP(8)

NAME

       fmtdump - decode nmh format files

SYNOPSIS

       /usr/lib/mh/fmtdump [-form formatfile] [-format string] [-version] [-help]

DESCRIPTION

       Fmtdump	is  a  program	that parses an nmh format file and produces a pseudo-language listing of the how nmh interprets the file.  This is
       useful when debugging a complicated format file.

       The -format string and -form formatfile switches may be used to specify a format string or format file to read.	The  string  is  simply  a
       format string and the file is simply a format file.  See mh-format(5) for the details.

FILES

       $HOME/.mh_profile	  The user profile
       /etc/nmh/scan.default	  The default format file

PROFILE COMPONENTS

       Path:		    To determine the user's nmh directory

SEE ALSO

       mh-format(5), mh-sequences(8)

CONTEXT

       None

BUGS

       The output may not be useful unless you are familiar with the internals of the mh-format subroutines.

MH.6.8								   11 June 2012 							FMTDUMP(8)
All times are GMT -4. The time now is 10:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy