Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: HELP - NEED Small Script ( or single awk Command)
Top Forums UNIX for Dummies Questions & Answers HELP - NEED Small Script ( or single awk Command) Post 302955065 by RavinderSingh13 on Monday 14th of September 2015 12:56:51 PM
Old 09-14-2015
Hello Nagarjuna4347,

Welcome to forums, please use code tags as per forum rules while using Inputs/codes/commands in your posts as per forum rules. Now coming on to your requirement, as you have shown us only TRANS_ALL, CTR_ACT, REF_NHA" for TRANSACTIONS, CTR_ACCOUNT, ACCOUNT respectively. Following code may help you in same. If you have more conditions then please provide us your same input with expected sample output too with code tags.
Code:
ls -lhtr CODS_ACTMZ* | awk -vs1="TRANS_ALL" -vs2="CTR_ACT" -vs3="REF_NHA" '{if($NF ~ s1){print $NF OFS $5 OFS "TRANSACTIONS"};if($NF ~ s2){print $NF OFS $5 OFS "CTR_ACCOUNT"};if($NF ~ s3){print $NF OFS $5 OFS "ACCOUNT"}}'

In my case I have created some test files so following is the output.
Code:
CODS_ACTMZ_REF_NHA_ALL_20150911.TXT 0 ACCOUNT
CODS_ACTMZ_REF_CTR_ACT_MIL_20150911.TXT 146 CTR_ACCOUNT
CODS_ACTMZ_TRANS_ALL_20150911.TXT 515 TRANSACTIONS

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Please help to debug a small shell script (maybe AWK problem)?

Hi Buddies, The following is shell scripts which was borrowed from linux box for load average check. it runs good. (this structure is simple, when load average is too high, it will send alert to user) #!/usr/bin/ksh # Set threshold for 1, 5 and 15 minture load avarage # configured for... (4 Replies)
Discussion started by: GreatJerry
4 Replies

2. Shell Programming and Scripting

Help with awk script, changing the FS for a single variable

Hi all, im new to awk and would apreciate if you could tell me how to do this, i have a file with several entries like this: 2008-09-09 21:57:45 44 403 CUSTOM_EVENT Upgrade - end1 2008-09-09 21:57:46 45 403 CUSTOM_EVENT Component Check - start... (3 Replies)
Discussion started by: sx3v1l_1n51de
3 Replies

3. Shell Programming and Scripting

Multiple pipes toward a single awk command

Hello, I would like to pipe two variables into awk, but I don't know how to do. Each variable, "a" and "b", are in fact a list of data. They are not files. So to get awk to work with it I am using: echo $a | awk 'FNR==NR{print $1}FNR!=NR{print $4}' The above works, but when I am... (5 Replies)
Discussion started by: jolecanard
5 Replies

4. Shell Programming and Scripting

awk, perl Script for processing a single line text file

I need a script to process a huge single line text file: The sample of the text is: "forward_inline_item": "Inline", "options_region_Australia": "Australia", "server_event_err_msg": "There was an error attempting to save", "Token": "Yes", "family": "Family","pwd_login_tab": "Enter Your... (1 Reply)
Discussion started by: hmsadiq
1 Replies

5. Shell Programming and Scripting

How can i use single quotes for SQL command in shell script

Hi. please help me to write the following query in a shell script. the Query is :select no,salary from emp_info where name='$var_name' the following is my code. #! /bin/sh var_name=$1 sqlplus -s user/pwd@DB << EOF select no,salary from emp_info where name="'$var_name'";... (4 Replies)
Discussion started by: little_wonder
4 Replies

6. Shell Programming and Scripting

How to alias an awk command with single and double quotes?

Hi, I am trying to write the following command as an alias in my .bashrc file. bjobs -u all | awk '{if (NR > 1) {username++;}}END{{print"\nJOBS BY USER:\n"} for (i in username) {print username,i;}{print"\n Total Jobs=",NR-1,"\n" }}' The command simply puts how many jobs each user is... (2 Replies)
Discussion started by: jacekmaciek
2 Replies

7. UNIX for Dummies Questions & Answers

single output of awk script processing multiple files

Helllo UNIX Forum :) Since I am posting on this board, yes, I am new to UNIX! I read a copy of "UNIX made easy" from 1990, which felt like a making a "computer-science time jump" backwards ;) So, basically I have some sort of understanding what the basic concept is. Problem Description:... (6 Replies)
Discussion started by: Kasimir
6 Replies

8. Shell Programming and Scripting

small sed script on command line.

Can anyone help me get this small sed script to work in shell on the command line? I need it in a one liner really as i want to edit many scripts in a for loop and dont want to have to invoke a separate script each time. #!/bin/sh sed '/mailx\ -s.*$ { i\ #Comment above mailx line ... (5 Replies)
Discussion started by: lavascript
5 Replies

9. Shell Programming and Scripting

awk command in script gives error while same awk command at prompt runs fine: Why?

Hello all, Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val: > cat getnon0file.sh #!/bin/bash this="getnon0file.sh" USAGE=$this" InFile="xyz.38" Min="0.05" # awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
Discussion started by: catalys
4 Replies

10. Shell Programming and Scripting

Require single command to start script in multiple servers

I have 9 servers, on each server a script with common name is available. I send a token file to all server from 1 particular server. so when a daemon job checks that token file is available then it triggers the script.. I want to know is there any command or script which I will run/execute on... (16 Replies)
Discussion started by: mirwasim
16 Replies

LEARN ABOUT SUSE

mc-tool

MC-TOOL(1)							     Utilities								MC-TOOL(1)

NAME

       mc-tool - manipulate Mission Control accounts from the command line

SYNOPSIS

       mc-tool list

       mc-tool add PROFILE DISPLAY-NAME [PARAMETER-SETTINGS...]

       mc-tool add MANAGER/PROTOCOL [PARAMETER-SETTINGS...]

       mc-tool update ACCOUNT [PARAMETER-SETTINGS...]

       mc-tool display ACCOUNT DISPLAY-NAME

       mc-tool nick ACCOUNT NICKNAME

       mc-tool icon ACCOUNT ICON

       mc-tool show ACCOUNT

       mc-tool get ACCOUNT PARAMETER [PARAMETER...]

       mc-tool auto-presence ACCOUNT STATUS [MESSAGE]

       mc-tool request ACCOUNT STATUS [MESSAGE]

       mc-tool auto-connect ACCOUNT on|off

       mc-tool remove ACCOUNT

DESCRIPTION

       mc-tool's usage depends on its first argument (the "command")

   SPECIFYING ACCOUNTS
       Where an account name is needed, it may be given as a full object path (e.g.  /org/freedesktop/Telepathy/Account/gabble/jabber/example), or
       as the unique account-specific suffix (e.g.  gabble/jabber/example).

   SPECIFYING PARAMETER SETTINGS
       Many commands take arguments that represent Telepathy connection manager parameters (see the Telepathy Specification for details of these).
       Each argument has the following form:

       TYPE:NAME=VALUE

       where  TYPE  is either int, uint, bool, or string (other parameter types exist, but are currently unsupported by mc-tool), NAME is the name
       of the connection manager parameter (e.g.  account or password), and VALUE is the parameter's value (with integers in decimal, and booleans
       as 0 or 1).

       The update command also accepts arguments of the form clear:NAME which delete the named parameter from the account configuration.

   LIST
       mc-tool list lists the available accounts.

   ADD
       mc-tool	add  adds  an  account.  The  connection  manager and protocol can either be given as the name of a Mission Control profile, (e.g.
       gtalk), or as a slash-separated connection manager name and protocol (e.g.  gabble/jabber).

   DISPLAY
       mc-tool display ACCOUNT DISPLAY-NAME sets the DisplayName property of ACCOUNT to DISPLAY-NAME.

   NICK
       mc-tool nick ACCOUNT NICKNAME sets the Nickname property of ACCOUNT to NICKNAME.

   ICON
       mc-tool icon ACCOUNT ICON sets the Icon property of ACCOUNT to ICON.

   SHOW
       mc-tool show ACCOUNT shows information about ACCOUNT.

   GET
       mc-tool get ACCOUNT PARAMETER [PARAMETER...]  shows the values of the given parameters of ACCOUNT.

   ENABLE
       mc-tool enable ACCOUNT sets the Enabled property of ACCOUNT to True.

   DISABLE
       mc-tool disable ACCOUNT sets the Enabled property of ACCOUNT to False.

   AUTO-PRESENCE
       mc-tool auto-presence ACCOUNT STATUS [MESSAGE] sets the AutomaticPresence property of ACCOUNT to STATUS with optional message MESSAGE.

   REQUEST
       mc-tool request ACCOUNT STATUS [MESSAGE] sets the RequestedPresence property of ACCOUNT to STATUS with optional message	MESSAGE;  this	is
       how you tell an account to connect or go offline, for example.

   AUTO-CONNECT
       mc-tool	auto-connect  ACCOUNT  on  sets the ConnectAutomatically property of ACCOUNT to True.  mc-tool auto-connect ACCOUNT off sets it to
       False.

Telepathy							     July 2009								MC-TOOL(1)
All times are GMT -4. The time now is 10:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy