Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Problem with awk
Top Forums Shell Programming and Scripting Problem with awk Post 302252549 by manmeet on Wednesday 29th of October 2008 07:36:12 PM
Old 10-29-2008
Problem with awk
I have a file from where i need to extrat 2nd column:
sample input is :
"THHSBC001900000006 CSG00100000 OTHOTH THB AA0100101100", "THHSBC001", "1-01-01", "THB"
"THHSBC001900273009 AOC00100000 OTHOTH THB AA0100106260", "THHSBC001", "1-01-01", "THB"
"THHSBC001902501940 SDY00100000 OTHOTH USD AA0100102000", "THHSBC001", "1-01-01", "USD"

the record in bold letter is just one record and so the other .
Now, columns are seperated by commas and
"THHSBC001900000006 CSG00100000 OTHOTH THB AA0100101100" is 1 st column
THHSBC001 is 2nd column
but when i try to extract 2nd column i.e. THHSBC001 using follwing code,

while read Record1
do
Acct_Num=`echo $Record1 | awk '{print $2 }'`
echo "Acct_Num is $Acct_Num"
done < $REGSeqFileName

i am getting CSG00100000 thing from 1st column , is there any way so that i can get desired ouput.

Thanks
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

AWK Problem

Hi, I posted something here about this yesterday but I can't seem to find it. I needed help writting a script which would append a file with new lines after every so many charachters. Example: (my original flat file) L60 LETTER OF CREDIT 60 DAYS W00 ON RECEIPT WIRE TRANSFER W30 NET... (12 Replies)
Discussion started by: gseyforth
12 Replies

2. Shell Programming and Scripting

Problem with AWK

Hi All, How can i store a value of the unix command executed in AWK with system command. devise=`cut -c1-3 dvgp.txt` I wrote this command in awk as awk'{ code= sprintf("devise=`cut -c1-3 dvgp.txt`"); system(code); }' Is this correct. can you please suggest me how the code can be... (1 Reply)
Discussion started by: krishna_gnv
1 Replies

3. Shell Programming and Scripting

problem using awk

Hi there every body I'm new to shell scripting and there is a problem facing me,, please look at the following piece of code: awk ' BEGIN{ FS="<assertion id=\1"; RS="<assertion id=\"2"}/<assertion id=\"1/{print FS$2 > "/home/ds2/test/output.txt"} ' filename all I wanna do is to... (6 Replies)
Discussion started by: senior_ahmed
6 Replies

4. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

5. Shell Programming and Scripting

Problem with awk awk: program limit exceeded: sprintf buffer size=1020

Hi I have many problems with a script. I have a script that formats a text file but always prints the same error when i try to execute it The code is that: { if (NF==17){ print $0 }else{ fields=NF; all=$0; while... (2 Replies)
Discussion started by: fate
2 Replies

6. Shell Programming and Scripting

awk problem

Find the number of files with sizes > 100KB in /, /bin, /usr, /usr/bin and /usr/sbin directories and output them in a two column format with the name of the directory and the number of files. i tried with awk $>ls -lh | awk '/^-/ && $5 >= 100k {print $8 $5}' but it is not working pls tell... (3 Replies)
Discussion started by: abhikamune
3 Replies

7. UNIX for Dummies Questions & Answers

Little problem with AWK

I thought I had solved this problem but after testing the script I came to realize that it is not doing what I need. So, here it goes again. This is the code: awk '/\>/{F=$2; N=$3; split(FILENAME, A, "."); getline; x = ">"}{print ">" A"-" x++" "F" " N"\n" $0}' This is the input file: ... (5 Replies)
Discussion started by: Xterra
5 Replies

8. Shell Programming and Scripting

awk problem - combining awk statements

i have a datafile that has several lines that look like this: 2,dataflow,Sun Mar 17 16:50:01 2013,1363539001,2990,excelsheet,660,mortar,660,4 using the following command: awk -F, '{$3=strftime("%a %b %d %T %Y,%s",$3)}1' OFS=, $DATAFILE | egrep -v "\-OLDISSUES," | ${AWK} "/${MONTH} ${DAY}... (7 Replies)
Discussion started by: SkySmart
7 Replies

9. Shell Programming and Scripting

awk problem

i have an email list in file.txt with comma separated line1 - FIELD1,pippo@gmail.com,darth@gmail.com line2 - FIELD2,pippo@gmail.com,darth@gmail.com,sampei@gmail.com output=(awk -F ',' -v var="$awkvar" '$1==var {print $2,$3,$4}' spreadsheet.txt)but awk delete some letters at the... (8 Replies)
Discussion started by: pasaico
8 Replies

10. Shell Programming and Scripting

awk problem

Hi I have two columns and I would like to create a third column based on how many lines away from a value of 1 in column 2, for example I have 1,0 2,0 3,0 4,0 5,0 6,1 7,0 8,0 9,0 10,0 11,1 And I want an output (6 Replies)
Discussion started by: garethsays
6 Replies

LEARN ABOUT SUSE

mrtg-logfile

MRTG-LOGFILE(1) 						       mrtg							   MRTG-LOGFILE(1)

NAME

       mrtg-logfile - description of the mrtg-2 logfile format

SYNOPSIS

       This document provides a description of the contents of the mrtg-2 logfile.

OVERVIEW

       The logfile consists of two main sections.

       The first Line
	   It stores the traffic counters from the most recent run of mrtg.

       The rest of the File
	   Stores past traffic rate averates and maxima at increassing intervals.

       The first number on each line is a unix time stamp. It represents the number of seconds since 1970.

DETAILS

       The first Line

       The first line has 3 numbers which are:

       A (1st column)
	   A timestamp of when MRTG last ran for this interface.  The timestamp is the number of non-skip seconds passed since the standard UNIX
	   "epoch" of midnight on 1st of January 1970 GMT.

       B (2nd column)
	   The "incoming bytes counter" value.

       C (3rd column)
	   The "outgoing bytes counter" value.

       The rest of the File

       The second and remaining lines of the file contains 5 numbers which are:

       A (1st column)
	   The Unix timestamp for the point in time the data on this line is relevant.	Note that the interval between timestamps increases as you
	   prograss through the file. At first it is 5 minutes and at the end it is one day between two lines.

	   This timestamp may be converted in OpenOffice Calc or MS Excel by using the following formula

	    =(x+y)/86400+DATE(1970;1;1)

	   (instead of ";" it may be that you have to use "," this depends on the context and your locale settings)

	   you can also ask perl to help by typing

	    perl -e 'print scalar localtime(x),"
"'

	   x is the unix timestamp and y is the offset in seconds from UTC. (Perl knows y).

       B (2nd column)
	   The average incoming transfer rate in bytes per second. This is valid for the time between the A value of the current line and the A
	   value of the previous line.

       C (3rd column)
	   The average outgoing transfer rate in bytes per second since the previous measurement.

       D (4th column)
	   The maximum incoming transfer rate in bytes per second for the current interval. This is calculated from all the updates which have
	   occured in the current interval. If the current interval is 1 hour, and updates have occured every 5 minutes, it will be the biggest 5
	   minute transfer rate seen during the hour.

       E (5th column)
	   The maximum outgoing transfer rate in bytes per second for the current interval.

AUTHOR

       Butch Kemper <kemper@bihs.net> and Tobias Oetiker <tobi@oetiker.ch>

2.16.2								    2008-05-16							   MRTG-LOGFILE(1)
All times are GMT -4. The time now is 07:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy