Required Command in awk command


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
Oracle Required Command in awk command

Hi Firends,

I wanted to extract the first record of the file which starst with character say "X". And I tried an awk command which works when i try to execute it individually:

Code:
awk 'substr($1,1,1)=="X"' inputfile.txt

But when I use the same command in my script for which I am passing the parameters, it extracts the first record and the last record:

Code:
 awk 'substr($0,$1,$2)==$3' $File_Name >> /WorkingDirectory/Header_Trailor.txt

where $1 = Character Length
$2 = Character Position
$3 = Search String

Please help me on this regard. Suggessions will be helpful.

Thanks,
Ajay
Moderator's Comments:
Mod Comment please use code tags next time for your cade and data
# 2  
If you are passing these parameters, then define awk variables and use them:
Code:
awk -v s="$1" -v l="$2" -v c="$3" 'substr($0,s,l)==c' "$File_Name"

# 3  
Thanks a lot Yoda.. It worked.... Smilie
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #493
Difficulty: Medium
When a program executes, each command executes one after the other, top-to-bottom. This is known as inconsequential control flow.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help required with move command

Hi I need to move the first file in a folder to an another folder but am facing issues with the below cmd. CAN someone correct me Ex : Folder :data/cat/tst ad2 ad4 ad5 ad6 output req: data/cat/man ad2 Command Used : ls -lt ad*|head -1|mv/data/cat/man (3 Replies)
Discussion started by: akshay01987
3 Replies

2. 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

3. Cybersecurity

Help Required: Command to find IP address and command executed of a user

Hi, I am trying to write a script which would figure out who has run which command and their IP. As i dont have any clue as to which commands would do this job, i request some gurus to help me on this. Thanks Vishwas (2 Replies)
Discussion started by: loggedout
2 Replies

4. Shell Programming and Scripting

Help Required regarding wc command

Hi guys, I want to find the number of records in a particular file and store that value in any other variable. I am trying this below command but it is not working and giving me an error "Uninary Operator Expected". say I have taken a variable name 'count' in which I have to store the no. of... (7 Replies)
Discussion started by: dtidke
7 Replies

5. Solaris

required command to know the port no.

Can anybody have the command to know the port no using unix command for the weblogic server application. (1 Reply)
Discussion started by: Amit_kolurwar
1 Replies

6. UNIX for Dummies Questions & Answers

Sed-- command help required

Hi Gurus, I have a small requirement. Let suppose i have a file test.txt test.txt contains Dispatched date = '2008-04-08' Name = 'Logers' Now i want to add one more line to it as Number of Responses = "$a" $a will be chnaging dynamically which i had grepped it in the script. Now i... (6 Replies)
Discussion started by: pssandeep
6 Replies

7. UNIX for Dummies Questions & Answers

Help required on AWK command

I have two questions: (Q1) I am using a loop and want to print a particular field of a table using the AWK command by accessing one row at a time by validating NR with the loop counter. I am using a command like this but it isn't working! count=1 NAWK -F"|" -v var=$count 'NR == var { printf... (13 Replies)
Discussion started by: udiptya
13 Replies

8. UNIX for Dummies Questions & Answers

Required help in chmod command

I have files inside the some directories. The no. of files in each directory will vary from 1 to 500K. I need to change the permissions of all the files to 400 mode. When the files are large in numbers...the command $chmod 400 * fails saying "ksh: /bin/chmod: arg list too long" so I have... (5 Replies)
Discussion started by: lokachari
5 Replies

9. UNIX for Dummies Questions & Answers

Help Required in Unix Command

Hi All, Can anyone please help me in unix command Query: ==== File contains data along with date and time stamp like, .. Date: 08:23:2005 01:00:00 method: xyz init variables Date 08:23:2005 01:00:01 method: xyz finished init variable .... (2 Replies)
Discussion started by: thaduka
2 Replies

10. Shell Programming and Scripting

Help required in grep command

Hi all, I need some help in grep command in a ksh script. Actually, i need to list all files having the file name like "BORD*.DAT" but exclude the files (from the list) having name like "BORD*mgt*.DAT". For that i used the following command: ls | grep "BORD*.DAT" | grep -v "BORD*mgt*.DAT" ... (4 Replies)
Discussion started by: panzer
4 Replies

Featured Tech Videos