any script for joining files based on simple conditions
Condition1;
If NPID and IndID of both input1 and input2 are same take all the vaues relevant to them and print together as output
Condition2;
IDNo in output: Take the highly repeated same letter of similar NPID-IndID as *1*
Second highly repeated same letter ...................................... as* 3*
Take different letters of .......................................... as *2*
Example (Check Bold Letters): Cond1: NPID (ID1) and IndID (a1,a2,a3,a6,a8,a9 ) of input1 similar to input2
input1
input2
]Desired Output
Thanx in advance
Last edited by zaxxon; 03-29-2010 at 04:04 AM..
Reason: even more code tags ;)
I've got two files, File1 and File2
File 1 has got combination of col1, col2 and col3 which comes on file2 as well, file2 does not get
col4. Now based on col1, col2 and col3, I would like to get col4 from file1 and all the columns from file2 in a new file
Any ideas?
File1
------
Col1 col2... (11 Replies)
I need a script (perl or awk..anything is fine) to join 3 files based on three key columns. The no of non-key columns can vary in each file. The columns are delimited by semicolon.
For example,
File1
Dim1;Dim2;Dim3;Fact1;Fact2;Fact3;Fact4;Fact5
---- data delimited by semicolon ---
... (1 Reply)
Hi
I have to join two files based on 1st column where 4th column of a2.txt=at and take 2nd column of a1.txt and 3rd column of a2.txt and check against source files ,if matches list those source file names.
a1.txt
a1|20090809|20090810
a2|20090907|20090908
a2.txt
a1|d|file1.txt|at... (9 Replies)
1. if the 1st row IDs of input1 (ID1/ID2.....) is equal to any IDNames of input2
print all relevant values together as defined in the output.
2. A bit tricky part is IDno in the output. All we need to do is numbering same kind of
letters as 1 (aa of ID1) and different letters as 2 (ab... (4 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Hi All,
I have a text file (code_data.txt) with the followig data.
AMAR AB123456 XYZ
KIRAN CB789 ABC
RAJ CS78890 XYZ
KAMESH A33535335 ABC
KUMAR MD678894 MAT
RITESH SR3535355... (26 Replies)
Using Linux (bash), I have two files which contain information about berries. Example:
file1.txt:
Blueberry blue 14
Raspberry red 12
Blackberry dark 4
file2.txt
Blackberry sour 4 3
Blueberry tasty 12 78
Strawberry yummy 33 88
I want to merge these two files into one. The desired... (5 Replies)
Hello!
New here although not completely new to Unix.
I wonder how I could rename files based on the data found in a simple textfile.
It goes like this:
I have 4 files
1 ldfgkkfjslkdfjsldkfjsf.wav
2 nndsdflksdjf.wav
3 sdflksjdf jjsdflsdfl.wav
4 dkadsdddd.wav
Textfile.txt looks like... (14 Replies)
Discussion started by: Oortone
14 Replies
LEARN ABOUT LINUX
plog
PON(1) Debian PPPD PON(1)NAME
pon, poff, plog - starts up, shuts down or lists the log of PPP connections
SYNOPSIS
pon [ isp-name [ options ] ]
poff [ -r ] [ -d ] [ -c ] [ -a ] [ -h ] [ isp-name ]
plog [ arguments ]
DESCRIPTION
This manual page describes the pon, plog and poff scripts, which allow users to control PPP connections.
pon
pon, invoked without arguments, runs the /etc/ppp/ppp_on_boot file, if it exists and is executable. Otherwise, a PPP connection will be
started using configuration from /etc/ppp/peers/provider. This is the default behaviour unless an isp-name argument is given.
For instance, to use ISP configuration "myisp" run:
pon myisp
pon will then use the options file /etc/ppp/peers/myisp. You can pass additional pppd options after the ISP name, too. pon can be used to
run multiple, simultaneous PPP connections.
pon takes the following command line options:
-q --quick
disconnect when ip-up finishes running. This function is only available to the root user.
poff
poff closes a PPP connection. If more than one PPP connection exists, the one named in the argument to poff will be killed, e.g.
poff myprovider2
will terminate the connection to myprovider2, and leave the PPP connections to e.g. "myprovider1" or "myprovider3" up and running.
poff takes the following command line options:
-r causes the connection to be redialed after it is dropped.
-d toggles the state of pppd's debug option.
-c causes pppd(8) to renegotiate compression.
-a stops all running ppp connections. If the argument isp-name is given it will be ignored.
-h displays help information.
-v prints the version and exits.
If no argument is given, poff will stop or signal pppd if and only if there is exactly one running. If more than one connection is
active, it will exit with an error code of 1.
plog
plog shows you the last few lines of /var/log/ppp.log. If that file doesn't exist, it shows you the last few lines of your /var/log/syslog
file, but excluding the lines not generated by pppd. This script makes use of the tail(1) command, so arguments that can be passed to
tail(1) can also be passed to plog.
Note: the plog script can only be used by root or another system administrator in group "adm", due to security reasons. Also, to have all
pppd-generated information in one logfile, that plog can show, you need the following line in your /etc/syslog.conf file:
local2.* -/var/log/ppp.log
FILES
/etc/ppp/options
PPPd system options file.
/etc/ppp/pap-secrets
System PAP passwords file.
/etc/ppp/chap-secrets
System CHAP passwords file.
/etc/ppp/peers/
Directory holding the peer options files. The default file is called provider.
/etc/chatscripts/provider
The chat script invoked from the default /etc/ppp/peers/provider.
/var/log/ppp.log
The default PPP log file.
AUTHORS
The p-commands were written by Christoph Lameter <clameter@debian.org>. Updated and revised by Philip Hands <phil@hands.com>.
This manual was written by Othmar Pasteka <othmar@tron.at>. Modified by Rob Levin <lilo@openprojects.net>, with some extensions taken from
the old p-commands manual written by John Hasler <jhasler@debian.org>.
SEE ALSO pppd(8), chat(8), tail(1).
Debian Project July 2000 PON(1)