Hi,
I have two files consisting of two columns. So I want to merge column 2 if column 1 is the same. So heres an example of what I mean.
FILE1
driver 444
car 333
hat 222
FILE2
driver 333
car 666
hat 999
So I want to merge the column 2's together so... (4 Replies)
Guys,
i have a file in below format where the barcode's are uniq per site but could be repeated for different site. so i want to convert the site column to rows based on the barcode's as below output.
your help is appreciated!!!
input:
SITE BARCODE QTY SP CP
10001 6281103890017 10 50 48... (5 Replies)
Hi All,
I do have 2 files
file 1 has 4 tab delimited columns
234 a c dfgyu
294 b g fih
302 c h jzh
328 z c san
597 f g son
File 2 has 2 tab delimted columns
234 23
302 24
597 24
I want to merge file 2 with file 1 based on the data common in both files which is the first column so... (6 Replies)
I had two files file1 and file2. I want a o/p file(file3) like below using first column as ref. Pls give suggestion ass join is not working as the number of lines in each file is nealry 5 C?
file1
---------------------
404000324810001 Y
404000324810004 N
404000324810008 Y
404000324810009 N... (1 Reply)
I have the following space-delimited input:
1 11.785710 117.857100
1 15 150
1 20 200
1 25 250
3 2.142855 21.428550
3 25 250
22 1.071435 10.714350
The first field is the ID number, the second field is the percentage of the total points that the person has and the third column is the number... (3 Replies)
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Hi,
I have a file which I'd like to merge lines based on duplicates in one column while keeping the info for other columns. Let me simplify it by an example:
File
ESR1 ANASTROZOLE NA FDA_approved
ESR1 CISPLATIN NA FDA_approved
ESR1 DANAZOL agonist NA
ESR1 EXEMESTANE NA FDA_approved... (3 Replies)
Hello :)
I am in this situation:
Input: two tab-delimited files, `File1` and `File2`. `File2` (`$2`) has to be parsed by patterns found in `File1` (`$1`).
Expected output: tab-delimited file, `File3`. `File3` has to contain the same rows as `File2`, plus the corresponding value in... (5 Replies)
I Want to merge multiple lines based on the 1st field and keep into single record.
SRC File:
AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2
CCC_POC_DB.TAB6
OUTPUT
-----------------
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
10 Replies
LEARN ABOUT SUSE
pilot-dlpsh
pilot-dlpsh(1) PILOT-LINK pilot-dlpsh(1)NAME
pilot-dlpsh - An interactive Desktop Link Protocol (DLP) Shell for your Palm device.
SECTION
pilot-link: Tools
SYNOPSIS
pilot-dlpsh [-p|--port <port>] [-c|--command STRING] [-i|--interactive] [--version]
OPTIONS
pilot-dlpsh options
-c,
--command STRING
Execute cmd and exit immediately.
-i, --interactive
Enter interactive mode
Conduit Options
-p,
--port <
port>
Use device file <port> to communicate with the Palm handheld. If this is not specified, pilot-dlpsh will look for the $PILOTPORT environ-
ment variable. If the port is missing and $PILOTPORT is not set, pilot-dlpsh will print the usage information.
--version
Display the copyright information, version number, license details and build details and exit without connecting.
DESCRIPTION
pilot-dlpsh allows the user to connect to a Palm handheld and execute arbitrary DLP commands.
pilot-dlpsh can query many different types of information from your Palm device, such as username, memory capacity, set the time, as well
as other useful functions.
Once connected, the user may execute most of the built-in DLP commands. (See BUILT-IN COMMANDS below for more detail on currently sup-
ported options).
The connection to the Pilot is kept alive by sending a PadTickle packet to the Pilot after a small period of non-activity. (7 seconds by
default)
BUILT-IN COMMANDS
There are many options available while connected to your Palm handheld via pilot-dlpsh, including the following:
user, u
Print the currently set User information, including Username, UserID, PCid, and ViewerID. You may also set these values from this command
as well. To set these values, simply pass the value to the option, such as 'user John Q. Public' for example.
ls
Used with -l and -r to provide long and RAM and ROM file lists, similar to (but slightly different from) the Unix 'ls' command. This does
not yet allow you to narrow your listing to a certain range of files. It will simply list them all.
df
Display how much RAM and ROM is free on your device, again similar to the Unix 'df' command. This does not accept arguments at this time.
ntp, time, dtp
Set the time on the Palm from the currently-set desktop time. This does not work on OS version 3.3, due to a bug in PalmOS at that time.
rm, del
Remove a file and delete it entirely from the Palm device. This is an irrevokable process, and you cannot "undelete" a file, once it has
been deleted with this command.
quit, q, exit, bye
Exit the DLP Protocol Shell
OPTIONS
Passing commandline options to pilot-dlpsh will allow you to interact with it in unattended mode, for example: 'pilot-dlpsh -p usb: -c
user' will connect and display the user information, just as if you had connected interactively and typed 'user' at the DLP shell prompt.
USAGE
The program will connect to your Palm handheld and give the user an interactive prompt (a "shell") for executing commands across the DLP
HotSync protocol.
AUTHOR
pilot-dlpsh was originally written by Chris Stevens <stevens@rpi.edu> and Damien Neil <neild@rpi.edu>
This manual page was updated to XML by Neil Williams <linux@codehelp.co.uk>
REPORTING BUGS
We have an online bug tracker. Using this is the only way to ensure that your bugs are recorded and that we can track them until they are
resolved or closed. Reporting bugs via email, while easy, is not very useful in terms of accountability. Please point your browser to
http://bugs.pilot-link.org: http://bugs.pilot-link.org and report your bugs and issues there.
COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA.
SEE ALSO pilot-link(7)0.12.5 Copyright 1996-2007 FSF pilot-dlpsh(1)