10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies
2. Shell Programming and Scripting
Hi,
I have the following output from an Oracle SQL statement and I want to remove duplicated column values.
I know it is possible using Oracle analytical/statistical functions but unfortunately I don't know how to use any of those.
So now, I've gone to PLAN B using awk/sed maybe or any... (5 Replies)
Discussion started by: newbie_01
5 Replies
3. Shell Programming and Scripting
Hi Forum.
I'm struggling to find a solution for the following issue.
I have multiple files a1.txt, a2.txt, a3.txt, etc. and I would like to insert a tab-delimited header record at the beginning of each of the files.
This is my code so far but it's not working as expected.
for i in... (2 Replies)
Discussion started by: pchang
2 Replies
4. Shell Programming and Scripting
Hi How to make tab delimited file to space delimited?
in put file:
ABC kgy
jkh ghj
ash kjl
o/p file:
ABC kgy
jkh ghj
ash kjl
Use code tags, thanks. (1 Reply)
Discussion started by: jagdishrout
1 Replies
5. Shell Programming and Scripting
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies
6. Shell Programming and Scripting
Hi Everyone,
Using shell script i am getting final file as attached below. In this 4th column value should be unique using any sequence.
for instance I've 1_13020_SSGM which is appearing 6 times in file and i should change it like 1_13020_SSGM_1,1_13020_SSGM_2,....1_13020_SSGM_6.
Can someone... (4 Replies)
Discussion started by: gehlnar
4 Replies
7. Shell Programming and Scripting
Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types:
(H)eader Records
(D)etail Records
(T)railer Records
The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies
8. Red Hat
I am trying to count the number of columns in a delimited flat file. The record is tab delimited. When I use the command wc -w, I am getting unexpected results when the record contains a NULL value. I believe it is because there is a "word" missing.
The below example will return 4 words... (2 Replies)
Discussion started by: nmalencia
2 Replies
9. Shell Programming and Scripting
Hi All,
The following is the scenario
id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....
I need the following output
id name
--------------
1 William
1 Johnson
2 Azim (2 Replies)
Discussion started by: kottursamy
2 Replies
10. Shell Programming and Scripting
I have a file which contains 1 million records of the following format. Each field is delimited by a pipe tilda pipe "|~|" show below. I would like to print only one column ie the CARDDESC value.
for example here it says CARDDESC=A8T1.
so anything after CARDDESC= and before |~|CARDTYPE is what... (11 Replies)
Discussion started by: knijjar
11 Replies
wcmgr(1) The Webalizer wcmgr(1)
NAME
wcmgr - Webalizer (DNS) Cache file Manager
SYNOPSIS
wcmgr [ option ... ] cache-file
DESCRIPTION
wcmgr is a utility program which allows manipulation of the DNS cache files used and produced by The Webalizer. Each record in the cache
file contains an IP address (either IPv4 or IPv6), a timestamp of when the entry was added to the cache, a flag to indicate if the record
contains a resolved name or not, and either the same IP address or a resolved host name. All records are accessed by their IP address.
RUNNING WCMGR
wcmgr was designed to be run from the Unix shell command line. This facilitates its use in shell scripts and other automated processes. A
valid DNS cache file must be specified. Command line options are optional, and if none are given, the default action is to list the con-
tents of the specified cache file.
COMMAND LINE OPTIONS
Different functions are selected by using one or more of the following command line options. If no options are given, the default is to
display the contents of the cache file to the screen (stdout).
-h Display all available command line options and exit.
-v Be verbose.
-V Display the program version and exit. Additional program specific information will be displayed if verbose mode is also used (e.g.
'-vV'), which can be useful when submitting bug reports.
-a address [-n hostname] [-t0]
Add a new record to the cache file. The IP address will be added to the cache file using the current time as the timestamp and
with a resolved name hostname. If -t0 is specified, the record will be considered permanent, and will not be removed (during a
purge) or expired. If a hostname is not specified with the -n option, then the address will be used instead, and the record will
be flagged as unresolved.
-c Create a new cache file. If used alone, this option will create a new, empty cache file. If used with the import option, a new
cache file will be created before importing the data. An error will occur if the file cache-file already exists.
-d address
Delete a record from the cache file using the specified address.
-f address
Find and display information for address from the cache file. A single line similar to that produced by the -l option will be dis-
played unless verbose mode is enabled, in which case a more detailed listing will be produced.
-i name [-c]
Import data into the cache file from the file name. The import file must be a valid tab delimited text file, such as that created
by the export option. If the imported data contains records already present in the cache file, those records will be overwritten
by the imported data. The cache file must exist unless the -c option is specified, in which case, a new cache file will be created
for the imported data.
-l List the contents of the cache file. This is the default action of the program, so does not necessarily need to be specified. If
verbose mode is enabled, a report title, column headers and summary totals will also be displayed.
-p num Purge the cache file of entries older than num days. If num is not specified, then a default of 7 days will be used. if verbose
mode is enabled, each purged record will be printed and the total number of purged records will be displayed.
-s [-t num]
Display cache file information/statistics. If a TTL value (in days) is specified using the -t option, it will be used to calculate
how many records are older than num days, otherwise, the default value of 7 days will be used.
-n name Specify the name to use as the resolved hostname when adding records to the cache.
-t num Time to live (TTL) value. If used along with the -p (purge) option, it specifies how many days a record will remain valid. Any
record that is older than num days is considered expired and will be purged. If used with the -a (add) option, a zero value will
cause the record to be considered permanent.
-x name Export data from a cache file to a tab delimited text file named name. If the text file name exists, it will be overwritten.
BUGS
Please report bugs to the author.
COPYRIGHT
Copyright (C) 1997-2011 by Bradford L. Barrett. Distributed under the GNU GPL. See the files "COPYING" and "Copyright", supplied with all
distributions for additional information.
AUTHOR
Bradford L. Barrett <brad at mrunix dot net>
Version 1.00 12-Jul-2008 wcmgr(1)