11-17-2008
Search flat file and return 3 fields
I need to be able to search a flat file (comma-separated values) for a specific value and then return the following 2 fields into variables. Here's a sample flat file:
SN,Account,IPaddress
W120394YF,adam,10.0.20.2
W394830PR,betty,10.0.20.3
W847582TD,charlie,10.0.20.4
W749509AY,donna,10.0.20.5
I already have BASH code that extracts the computer's serial number and stores it to SERIALNUM. I want to search the file for that SERIALNUM and return the following 2 fields in ACCT and IPADD. Suggestions?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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
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
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 V7
opannotate
OPANNOTATE(1) General Commands Manual OPANNOTATE(1)
NAME
opannotate - produce source or assembly annotated with profile data
SYNOPSIS
opannotate [ options ] [profile specification]
DESCRIPTION
opannotate outputs annotated source and/or assembly from profile data of an OProfile session. See oprofile(1) for how to write profile
specifications.
OPTIONS
--assembly / -a
Output annotated assembly. If this is combined with --source, then mixed source / assembly annotations are output.
--demangle / -D none|smart|normal
none: no demangling. normal: use default demangler (default) smart: use pattern-matching to make C++ symbol demangling more read-
able.
--exclude-dependent / -x
Do not include application-specific images for libraries, kernel modules and the kernel. This option only makes sense if the profile
session used --separate.
--exclude-file [files]
Exclude all files in the given comma-separated list of glob patterns.
--exclude-symbols / -e [symbols]
Exclude all the symbols in the given comma-separated list.
--help / -? / --usage
Show help message.
--image-path / -p [paths]
Comma-separated list of additional paths to search for binaries. This is needed to find modules in kernels 2.6 and upwards.
--root / -R [path]
A path to a filesystem to search for additional binaries.
--include-file [files]
Only include files in the given comma-separated list of glob patterns.
--include-symbols / -i [symbols]
Only include symbols in the given comma-separated list.
--objdump-params [params]
Pass the given parameters as extra values when calling objdump.
--output-dir / -o [dir]
Output directory. This makes opannotate output one annotated file for each source file. This option can't be used in conjunction
with --assembly.
--search-dirs / -d [paths]
Comma-separated list of paths to search for source files. You may need to use this option when the debug information for an image
contains relative paths.
--base-dirs / -b [paths]
Comma-separated list of paths to strip from debug source files, prior to looking for them in --search-dirs.
--session-dir=dir_path
Use sample database out of directory dir_path instead of the default location (/var/lib/oprofile).
--source / -s
Output annotated source. This requires debugging information to be available for the binaries.
--threshold / -t [percentage]
Only output data for symbols that have more than the given percentage of total samples.
--verbose / -V [options]
Give verbose debugging output.
--version / -v
Show version.
ENVIRONMENT
No special environment variables are recognised by opannotate.
FILES
/var/lib/oprofile/samples/
The location of the generated sample files.
VERSION
This man page is current for oprofile-0.9.6.
SEE ALSO
/usr/share/doc/oprofile/, oprofile(1)
4th Berkeley Distribution Tue 06 July 2010 OPANNOTATE(1)