02-09-2009
Use awk...
echo "1|trunc(sysdate-1)|substring(pcol)" | awk -F "|" '{print NF-1}'
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Greetings,
I need to search and count all the occurences of a word in all the files in a directory.
Any suggestions greatly appreciated.
Thanks (1 Reply)
Discussion started by: skoppana
1 Replies
2. Shell Programming and Scripting
i want to search a word in a file and find the count of occurences even if pattern occures twice in a same line.
for example file has the following content.
yes no no nooo yees
no yes
if I search for "no" it should give count as 4
Pls help.
Thanks (9 Replies)
Discussion started by: RahulJoshi
9 Replies
3. UNIX for Dummies Questions & Answers
I need to search and count the occurrences of a pattern in a file. The catch here is it's a pattern and not a word ( not necessarily delimited by spaces). For eg. if ABCD is the pattern I need to search and count, it can come in all flavors like (ABCD, ABCD), XYZ.ABCD=100, XYZ.ABCD>=500,... (6 Replies)
Discussion started by: tektips
6 Replies
4. Shell Programming and Scripting
hi All,
need help. have a file like below
A, error in 123
B, log files are present
A, error in 23444
B, log files are present
A, move to next line
C, matching messages
-- expected output--
A , count =2 , error in *
A , count =1 , move to next line
B , count =2 , log files are present... (2 Replies)
Discussion started by: arun1401
2 Replies
5. Shell Programming and Scripting
Hi all,
I need to search the database log find out the most frequently used tables for a certain period of time.
The search pattern is : the database.table
so, i need to look for ABCD.* in the entire log and then need the top ten tables.
I thought of using awk, search for the pattern ... (7 Replies)
Discussion started by: ysvsr1
7 Replies
6. Shell Programming and Scripting
Hi,
I have 2 files.
file1:
ABC 1160 1260
DEF 1360 1580
DEF 2300 2800
XYZ 1600 2200
file2:
chr1_1000_1050
chr1_1100_1150
chr3_1151_1200
chr3_1201_1250
chr6_1301_1350
chr6_1351_1400
chr6_1550_1600
chrX_1600_1650
chrX_1851_1900 (8 Replies)
Discussion started by: Diya123
8 Replies
7. Shell Programming and Scripting
Hi,
I have a text file the contents are like this
now i want to search patterns Z , Z etc and count the occurrence of such patterns, after Z value can be any random digits, please help me it is urgent...
output like this
Z .............>5
Z ............>8 (9 Replies)
Discussion started by: sreejithalokkan
9 Replies
8. UNIX for Dummies Questions & Answers
Hi,
Is there a command to do a sensitive/in-sensitive search for a string on a line and print how many times that string appears?
For example, if I have a line of text below:
dog cat rat apple banana dog lion tiger dog
Is there a command to search for dog that will print out 3 as a... (7 Replies)
Discussion started by: newbie_01
7 Replies
9. UNIX for Dummies Questions & Answers
Hi Guys,
I have a file as follows. Here is my story:
For each field, the string in the 5th column needs to be searched in other fields of the same column and counted if the 1st column of the field is different from that of the primary field. BTW, the unique strings of 1st column need to be... (6 Replies)
Discussion started by: a_bahreini
6 Replies
10. Shell Programming and Scripting
Input:
|Running the Rsync|Sun Oct 16 22:48:01 BST 2016
|End of the Rsync|Sun Oct 16 22:49:54 BST 2016
|Running the Rsync|Sun Oct 16 22:54:01 BST 2016
|End of the Rsync|Sun Oct 16 22:55:45 BST 2016
|Running the Rsync|Sun Oct 16 23:00:02 BST 2016
|End of the Rsync|Sun Oct 16 23:01:44 BST 2016... (4 Replies)
Discussion started by: busyboy
4 Replies
LEARN ABOUT DEBIAN
rapt-file
RAPT-FILE(1) RAPT-FILE(1)
NAME
rapt-file - APT package searching utility -- search remotely
SYNOPSIS
rapt-file [ options ] [ action ] [ pattern ]
DESCRIPTION
rapt-file is a command line tool for searching files in packages for the APT package management system. It differs from apt-file in that
it works with remote package indices, so it doesn't need to download full Contents files.
find Alias for search.
list List the contents of a package matching the pattern pattern. This action is very close to the dpkg -L command except the package
does not need to be installed or fetched.
search Search in which package a file is included. A list of all packages containing the pattern pattern is returned.
rapt-file will only search for filenames, not directory names. This is due to the format of the Contents files it searches.
show Alias for list.
OPTIONS
-a, --architecture architecture
Sets architecture to architecture. This option is useful if you search a package for a different architecture from the one installed
on your system. It determines how the $ARCH variable in sources.list is expanded (but it does not influence the search in any other
way).
-l, --package-only
Only display package name; do not display file names.
-v, --verbose
Run rapt-file in verbose mode.
-h, --help
Display a short help screen.
FILES
/etc/apt/sources.list
Locations to fetch package contents from.
/etc/apt/sources.list.d/
Directory with additional sources.list snippets
AUTHOR
rapt-file was written by Enrico Zini <enrico@debian.org>.
May 2012 RAPT-FILE(1)