Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search flat file and return 3 fields
Top Forums Shell Programming and Scripting Search flat file and return 3 fields Post 302259718 by da2357 on Tuesday 18th of November 2008 09:23:32 PM
Old 11-18-2008
Quote:
Originally Posted by da2357
Any final ideas?
Eureka, I found it!

Code:
#!/bin/bash
USERLIST="/Users/johndoe/.bin/xBackup_users"
SRCHFOR="W8735UL8Z5V"
#
USERNAME=`awk -F "," '/^'"$SRCHFOR"'/ {print $2}' $USERLIST`
PASSWORD=`awk -F "," '/^'"$SRCHFOR"'/ {print $3}' $USERLIST`
RSYNCIP=`awk -F "," '/^'"$SRCHFOR"'/ {print $4}' $USERLIST`
#
clear
echo
echo Your account name is $USERNAME
echo Your password is $PASSWORD
echo Your IP address is $RSYNCIP
echo
exit

Thanks to everyone for your ideas.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script to return all the ID's from file based on the distribution ID search

Hi, Please help me out on this I have to store some distribution lists(dl) in a file say mail.txt Say the file format be d1 = alok@yahoo.co.in;alvin@rediffmail.com;vijay@yahoo.com; & so on... d2 = abhinav@gmail.com;dalpit@hotmail.com;garima@yahoo.com;& so on... d3 = .... & so on Now what... (1 Reply)
Discussion started by: kumbhatalok
1 Replies

2. UNIX for Dummies Questions & Answers

Search for String within File and Return File Name

How do I search for a string within a file and return the names of the file that contain the string? I would like to search directories and sub-directories. (4 Replies)
Discussion started by: bggibson
4 Replies

3. Shell Programming and Scripting

search fields within a file

I need to be able to search multiple fields within a file that contain blank (nothing). Not sure what command to use? thought it would be grep but not sure how to write it The reason is i have a script that when it does this and identifies a field which has a blank it errors out of the script... (4 Replies)
Discussion started by: Pablo_beezo
4 Replies

4. Shell Programming and Scripting

`find`, pulling 1st field from ASCII flat file as search/-name?

Hey Everyone! I have searched around for this on Unix.com and Google, and I'm either not phrasing my search properly or this is not as simple as I thought... I have a script that runs on a nightly basis that pulls one field worth of data from an internal MySQL database and populates to an... (2 Replies)
Discussion started by: Gecko12332
2 Replies

5. UNIX for Dummies Questions & Answers

Search flat file in specific byte

I am on AIX Unix. I want to read a flat file for a string in a certain byte. I want to find the value: 943034 in column 56; and write out just those records to another file. Also, could I get the line/record number of where it was found in the input file? Thank you, sboxtops (1 Reply)
Discussion started by: sboxtops
1 Replies

6. UNIX for Dummies Questions & Answers

Search specific pattern in file and return number of occurence

Hi I want to search for a specific pattern in file Say ABC;HELLO_UNIX_WORLD;PQR ABC;HELLO_UNIX_WORLD_IS_NOT_ENOUGH;XYZ ABC;HELLO_UNIX_FORUM;LMN Pattern to search is : "HELLO_UNIX_*****" and not "HELLO_UNIX_***_***_" I mean after "HELLO_UNIX" there can only be one word.In this case... (2 Replies)
Discussion started by: dashing201
2 Replies

7. Shell Programming and Scripting

search a string in a particular column of file and return the line number of the line

Hi All, Can you please guide me to search a string in a particular column of file and return the line number of the line where it was found using awk. As an example : abc.txt 7000,john,2,1,0,1,6 7001,elen,2,2,0,1,7 7002,sami,2,3,0,1,6 7003,mike,1,4,0,2,1 8001,nike,1,5,0,1,8... (3 Replies)
Discussion started by: arunshankar.c
3 Replies

8. Shell Programming and Scripting

gawk script to search and replace text in a flat file

Hi I am new to unix and newbie to this forum. I need help in writing a gawk script that search and replace particular text in a flat file. Input file text : ZIDE_CONTROL000 100000000003869920900000300000001ISYNC 000002225489 0000000002232122 20120321 16:40:53 ZIDE_RECORD000... (5 Replies)
Discussion started by: gkausmel
5 Replies

9. Shell Programming and Scripting

awk to delete fields from flat file

I would like to know awk command to delete the specific feild from a flat file delimited by '|' if the first feild starts with 354 I tried awk 'BEGIN {FS=OFS="|"} {$16=""; sub(/\|/, "")}'1 Input file: 354|||||GROUND||97||JUDD STREET|||LONDON||WC1H 9JG|ADI001| 354|||||FLAT 1... (10 Replies)
Discussion started by: Aditya_001
10 Replies

10. Shell Programming and Scripting

How to search for blank fields in a text file from a certain position?

Sample txt file : OK00001111112| OK00003443434|skjdaskldj OK32812983918|asidisoado OK00000000001| ZM02910291029|sldkjaslkjdasldjk what would be the shell script to figure out the blank space (if any) after the pipe sign? (4 Replies)
Discussion started by: chatwithsaurav
4 Replies

LEARN ABOUT DEBIAN

userlist

USERLIST(8)						      Finger-type Userlisting						       USERLIST(8)

NAME

       userlist - Userlisting of who's on your system.

SYNOPSIS

       userlist

DESCRIPTION

       This  program simply gives you a listing of who is connected to your system.  It is used primarily in the sorted listing of cfingerd, which
       utilitizes the same method of display for a more uniform output between systems.  (It also made more sense to do it  this  way  instead	of
       having jumbled up display listings in sorted finger displays.  Besides, it made more sense to do this than use finger.  :)

       This program functions with the same types of things in mind that cfingerd does.  If the user has a .nofinger file, their username will not
       be displayed in the userlisting.

       Example output is shown as:

	Username Real Name	Idletime TTY Remote console
	username I'm real ...	9d 23:59   0 (remote.site.com)

       where it would display the user's login name, the user's real name, their idle time given in the format "dd hh:mm", their  TTY,	and  their
       remote location (or where they're telnetting from).

       If  the	username  is  over  8  characters, the program will not search for their information in the passwd file, since it may be too long.
       Besides, it checks getpwnam, anyway.  :)

OPTIONS

       -c     Give standard CFINGERD (custom) output.

       -n     List only people idle less than one day.

ADDITIONAL

       Although userlist is not required to run as suid root, it is a good idea.  The reason is it checks each users' directory  for  a  .nofinger
       file.  If indeed that user has a .nofinger file in his/her directory, that user will not be shown in the userlisting.

       If  you change the program to run as nobody.nobody, you are free to do so.  But you will also show the users if they are online, regardless
       of whether or not they have a ".nofinger" file (as long as their directory is NOT world-readable.)

CONTACTING

       If you like this program, have any suggestions on how it could be modified, or have bug reports, please write to: khollis@bitgate.com.

       Your continued Public Domain support is appreciated!  Thanks.

SEE ALSO

       cfingerd.conf(5), cfingerd(8), finger(1).

cfingerd 1.4.2							  29 August 1999						       USERLIST(8)
All times are GMT -4. The time now is 11:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy