How to read a particular records from a file?

Login or Register to Ask a Question and Join Our Community

How to read a particular records from a file?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to read a particular records from a file?

04-14-2013

Registered User

1, 0

Join Date: Apr 2013

Last Activity: 14 April 2013, 2:04 PM EDT

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to read a particular records from a file?

Hi All

Can anybody let me know the code to read a particular record from a file

For e.g.

File Name: File.txt
File content:

Code:

Script_path=/abc/def/script/
File_path=/xyz/data/
Business Date=19990905
SERVER_NAME=Server
DATABASE_NAME=Database
Login=NewUser
Password=NewPassword

Now I want to write shell (ksh) script, using which I can read Business date value i.e.19990905

Last edited by Scrutinizer; 04-15-2013 at 01:45 AM.. Reason: code tags

Siddhartha9833

View Public Profile for Siddhartha9833

Find all posts by Siddhartha9833

04-14-2013

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

There are lots of ways to do this. One simple way is:

Code:

sed -n 's/Business Date=//p' File.txt

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

04-15-2013

Moderator

3,689, 1,352

Join Date: Jan 2012

Last Activity: 22 August 2020, 11:29 PM EDT

Location: Galactic Empire

Posts: 3,689

Thanks Given: 268

Thanked 1,352 Times in 1,258 Posts

Using KSH

Code:

#!/bin/ksh

while IFS="=" read var val
do
        [[ "$var" = "Business Date" ]] && printf "${val}\n"
done < file.txt

Using awk

Code:

awk -F'=' '/Business Date/{print $NF}' file.txt

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

04-15-2013

Registered User

269, 23

Join Date: Dec 2011

Last Activity: 15 November 2016, 10:59 PM EST

Posts: 269

Thanks Given: 2

Thanked 23 Times in 23 Posts

you can try also

Code:

grep 'Business Date' test1.txt

bmk

View Public Profile for bmk

Find all posts by bmk

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read File and check records for length

I need a script that will run in unix to: 1) Read and input file with 1 column that contains for ex: 0123456789 1234567890 ...etc 2) Checks the first column if it is: a. Numeric from 0 - 9 b. if it is not less...

2. Shell Programming and Scripting

How to read records in a file and sort it?

I have a file which has number of pipe delimited records. I am able to read the records....but I want to sort it after reading. i=0 while IFS="|" read -r usrId dataOwn expire email group secProf startDt endDt smhRole RoleCat DataProf SysRole MesgRole SearchProf do print $usrId $dataOwn...

3. Shell Programming and Scripting

Read a file with n records as one big string using linux

Hello! Is there a way i can read a file with n records as one big string using linux shell script? I have a file in the below format - REC1 REC2 REC3 . . . REC4 Record length is 3000 bytes per record and with a newline char at the end. What i need to do is - read this file as one...

4. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that...

5. Shell Programming and Scripting

How to read each 2 records from a file

Hi, I have 10000 records in my test.dat file All records are under the following format a,12,45,bn,c a,16,46,bn1,c a,18,47,bn2,c a,12,47,bn3,c a,11,49,bn4,c I have to read each 2 records and assign it into a temp file .Can anybody help me in this? Thanks

6. Shell Programming and Scripting

how to read next records

Hello friends, I am newbie in programing. I am facing some problems in awk. Please help me. I have a file with many data sets. Each data set is separated by an empty line. For example Col1 Col2 Col3 Col4 Col5 0.85 0.07 Fre 42:86 25 0.73 0.03 frp 21:10 28 0.64 0.04 Fre 42:86 63 0.47 0.08...

7. Shell Programming and Scripting

need shell script to read particular records from a file

i am reading an i/p file input.txt as below and want to read all filenames as in highlighted in bold below and put them in a different file output.txt. can someone help me with a shell script to do this? thanks in advance regards brad input.txt --------- START TYPE:OPT INIT_SEQ:01...

8. Shell Programming and Scripting

read records from a file

Hi all, I have a requirement where I need to read records one by one from a file. I have tried this below code: while read mLine do echo 'Line = '${mLine} done < input_file --- But the problem here is im getting the records with removed spaces. --Supposer if the record is like...

9. Shell Programming and Scripting

Count No of Records in File without counting Header and Trailer Records

I have a flat file and need to count no of records in the file less the header and the trailer record. I would appreciate any and all asistance Thanks Hadi Lalani

10. Shell Programming and Scripting

How to read a particular line in a file with 500000 records init

I am trying to open a file and check a record. The file has 543267 records and I want to check the record 514455. I am trying to open in vi and go to that line :514455 but i get the error not enough lines in buffer How should i overcome this? Please help.

Login or Register to Ask a Question