Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with Script using awk
Operating Systems Solaris Help with Script using awk Post 303003049 by dakelly on Thursday 7th of September 2017 06:55:54 AM
Old 09-07-2017
Help with Script using awk
Hi All,

I need to create a script to look at a very long list of files, and look inside these files for a specific number of a special character "," there needs to be no more than 14 in each line in each file.

I have copied 2 files for testing the script.

Code:
dk@server: /export/home/test> ls -alt DK* | awk '{ print $9 }'
DK_TEST2.dat
DK_TEST.dat
dk@server: /export/home/test>

these files look something like this (not exact content, but close - to protect data)
Code:
,,30035111,DAVY KELLY JOB NO. 17748000,16940000,04/09/2017,04/09/2017,P001111,10.2,10,1.02,Davy Kelly,1,,
,,30035111,DAVY KELLY JOB NO. 17748000,16940000,04/09/2017,04/09/2017,P001111,13.62,6,2.27,Davy Kelly,2,,
,,30035111,DAVY KELLY JOB NO. 17748000,16940000,04/09/2017,04/09/2017,P029111,16.91,1,16.91,Davy Kelly,3,,
,,30035111,DAVY KELLY JOB NO. 17748000,16940000,04/09/2017,04/09/2017,P029111,16.91,1,16.91,Davy Kelly,4,

I am looking to:
make a list of the filenames in the path that contain DK* save as LIST
for each FILE in LIST
Check via AWK for more than 14 commas - if true print FILENAME to OUTPUT file
mail out OUTPUT file to myself.

Code:
#!/bin/sh
###
###  Name:         check_excesiveComma.sh
###  Path:          /export/home/test
###  Description:  Copy a list of Filenames that have more than 14 commas
###  Version:      1.1
###  Author:       DKelly
###

FPATH=/export/home/test
DAT=`date`
MSG=/tmp/email.txt
OUTPUT=/tmp/output.txt
LIST=/tmp/list.txt

touch $LIST
ls -alt DK* | awk '{ print $9 }' >> $LIST

###  Change Directory to $FPATH
cd $FPATH

###  Check all files for more than 14 commas and output the filenams
for FILE in $LIST
do
    if (`awk 'BEGIN -F"," {NF > 14}`) then echo $FILE >> $OUTPUT
done

###  Mail out the message and delete the output and message
cat $MSG | /usr/bin/mailx -s"Graftons Files that might cause issues" davy

###  remove files.
rm $MSG
rm $LIST
rm $OUTPUT

###  end script

Don't worry I know I have a variable for MSG and this is really the one i want to email...

I am not really getting AWK very well... I need to look in the each file in the List, count each line for commas, and echo out the Actual Filename if one of the lines has more than 14 commas.

Please could you kind people point me in the right direction.

davy
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies

2. Shell Programming and Scripting

want to pass parameters to awk script from shell script

Hello, I have this awk script that I want to execute by passing parameters through a shell script. I'm a little confused. This awk script removes duplicates from an input file. Ok, so I have a .sh file called rem_dups.sh #!/usr/bin/sh... (4 Replies)
Discussion started by: script_op2a
4 Replies

3. Shell Programming and Scripting

Call shell script function from awk script

hi everyone i am trying to do this bash> cat abc.sh deepak() { echo Deepak } deepak bash>./abc.sh Deepak so it is giving me write simply i created a func and it worked now i modified it like this way bash> cat abc.sh (2 Replies)
Discussion started by: aishsimplesweet
2 Replies

4. Shell Programming and Scripting

Help: How to convert this bash+awk script in awk script only?

This is the final first release of the dynamic menu generator for pekwm (WM). #!/bin/bash function param_val { awk "/^${1}=/{gsub(/^${1}="'/,""); print; exit}' $2 } echo "Dynamic {" for CF in `ls -c1 /usr/share/applications/*.desktop` do name=$(param_val Name $CF) ... (3 Replies)
Discussion started by: alexscript
3 Replies

5. Shell Programming and Scripting

Passing awk variable argument to a script which is being called inside awk

consider the script below sh /opt/hqe/hqapi1-client-5.0.0/bin/hqapi.sh alert list --host=localhost --port=7443 --user=hqadmin --password=hqadmin --secure=true >/tmp/alerts.xml awk -F'' '{for(i=1;i<=NF;i++){ if($i=="Alert id") { if(id!="") if(dt!=""){ cmd="sh someScript.sh... (2 Replies)
Discussion started by: vivek d r
2 Replies

6. Shell Programming and Scripting

Calling shell script within awk script throws error

I am getting the following error while passing parameter to a shell script called within awk script. Any idea what's causing this issue and how to ix it ? Thanks sh: -c: line 0: syntax error near unexpected token `newline' sh: -c: line 0: `./billdatecalc.sh ... (10 Replies)
Discussion started by: Sudhakar333
10 Replies

7. Post Here to Contact Site Administrators and Moderators

Unable to pass shell script parameter value to awk command in side the same script

Variable I have in my shell script diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new I could see value of $id is not passing to the awk... (0 Replies)
Discussion started by: Ashunayak
0 Replies

8. UNIX for Dummies Questions & Answers

Passing shell script parameter value to awk command in side the script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff |... (1 Reply)
Discussion started by: Sarita Behera
1 Replies

9. Shell Programming and Scripting

awk script to call another script based on second column entry

Hi I have a text file (Input.txt) with two column entries separated by tab as given below: aaa str1 bbb str2 cccccc str3 dddd str4 eee str3 ssss str2 sdf str3 hhh str1 fff str2 ccc str3 ..... ..... ..... (1 Reply)
Discussion started by: my_Perl
1 Replies

10. UNIX for Beginners Questions & Answers

Shell script to call and sort awk script and output

I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 Replies

LEARN ABOUT OPENSOLARIS

install-solaris

install-solaris(1M)                                                                                                            install-solaris(1M)

NAME

       install-solaris - install the Solaris operating system

SYNOPSIS

       install-solaris

       install-solaris  invokes  the  Solaris  Install  program. Depending on graphical capability and available memory at the time of invocation,
       install-solaris invokes either a text-based installer or a graphical installer.

       The following minimum requirements for physical memory dictate which features are available during installation:

       For SPARC machines:

       128 MB

           Minimum physical memory for all installation types

       128 MB

           Minimum physical memory required for windowing system

       384 MB

           Minimum physical memory required for graphical-based installation

       For x86 machines:

       256 MB

           Minimum physical memory for all installation types

       256 MB

           Minimum physical memory required for windowing system

       512 MB

           Minimum physical memory required for graphical-based installation

       In some cases, even if the minimum physical memory is present, available virtual memory after system startup can limit the number  of  fea-
       tures available.

       install-solaris  exists  only  on  the Solaris installation media (CD or DVD) and should be invoked only from there. Refer to the  for more
       details.

       install-solaris allows installation of the operating system onto any standalone system. install-solaris loads the software available on the
       installation media. Refer to the  for disk space requirements.

       Refer to the  for more information on the various menus and selections.

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE         |      ATTRIBUTE VALUE        |
       +-----------------------------+-----------------------------+
       |Availability                 |SUNWcdrom  (Solaris instal-  |
       |                             |lation media)                |
       +-----------------------------+-----------------------------+
       |Interface Stability          |Evolving                     |
       +-----------------------------+-----------------------------+

       pkginfo(1), install(1M), pkgadd(1M), attributes(5)

       It is advisable to exit install-solaris by means of the exit options in the install-solaris menus.

                                                                    23 Sep 2005                                                install-solaris(1M)
All times are GMT -4. The time now is 09:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy