Input file (already sorted on the key field):
204 Daniel Barton
206 Mary Halston
206 David Coleman
206 Carson Coleman
207 Roland Highsmith
207 Annie Highsmith
209 Connie Ward
Desired output file:
204 Daniel Barton
206 Mary Halston David Coleman Carson Coleman
207 Roland Highsmith Annie Highsmith
209 Connie Ward
I have multiple .xls documents that are formatted as such,
<?xml version="1.0"?>
<?mso-application Excel.Sheet?>
They are all given different filenames bob_smells.xls, nancy_smells_worse.xls etc. I was wondering using Linux (LUbuntu specifically), would it be possible to combine all of these worksheets into one document, with each of the seperate files becoming a tab / sheet within the one file (And the name reflecting the original name of the document)?
I have a Lenny Raid-5 setup, and I use rsnapshot to occasionally backup the raid to an old external hard drive that I otherwise leave unplugged. That external went bad, so I figured I should setup its replacement with encryption and keep it off site when not in use.
While googling and coming across LUKS, I can across this post this post that mentioned the drive should be be filled with random data before setting it up for encryption, and had the following as a potential sufficiently-good option over the time-intensive dd /dev/random route:
badblocks -c 10240 -s -w -t random -v /dev/sdx
I was unfamiliar with badblocks, and came across this post after a google session which noted the time duration of scan is an important factor as well as the result.
I sshed into the NAS, and was about to run badblocks first in read mode, then in write mode, but then I considered the time consideration. I was going to use something similar to the following: nohup badblocksstuff &
My Question: Is there a way I can append to the resulting nohup.out a time to complete value?
I'm using Net::Bluetooth to create an RFCOMM socket on my Linux box. I need for it to register with SDP with a specific UUID. The perl code can be viewed in this link. I am unable to make the connection from a remote device however. This remote device (my Android phone) is able to connect to other RFCOMM devices using this UUID. I would like to troubleshoot the problem, but I can't find a way to browse the LOCAL SDP records of my PC where the Perl script is running (and waiting for incoming BT connections). how to browse the SDP records on the local PC?
View 1 Replies View RelatedI am using awstat for a website. It's working fine. On the webserver I made a new virtual host for the same website with some addition in URL. I made a separate log file for this URL and tried to process it also in awstat but for it's log file awstat is dropping all records.
On webserver log format is same for both logs files. On awstat the config file is same for both logs except the log path line of course .Why awstat isn't able to process the same log format with the same config file what is working for the previous logs
I am having a log file where there is some discontinuous of dates are there but if i go for range of date to find the records, if is some date is missing the result is displaying full file list( Start date to end of file ) How could i restrict the result upto the mentioned date range.
Code:
$cat sample.log
Jan 03 -error yyyy-1234
[code]...
I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 Replies View RelatedI have been asked to write a program to extract the width and height values from .gif, .jpg and .png files. For .gif I was able to find the values in the header records, but it is not so straight forward for the other two formats.
Does anyone know if there is a Linux utility that will do this for me?
there is a tool, which can check and compare DNS records for me. I'd like to tell it to look at our private subnet, and it for to return records which have missing or different DNS records, than were expected. if it just looked up every record and returned it in a "neat" way, that'd work too.
View 5 Replies View RelatedI have a database (Mysql) with records of our club members. It is quite small only about 300 records. Unfortunately there are gaps in the information and I would like to be able to print out (two records to an A4 sheet) the records in form format so that I can pass these to the members who will fill in any blanks in the record.
If it is not possible to do what I want from the database I can convert the records to a spreadsheet and do it from there.
Unable to delete dupliucate DNS records using bcupdate tool
View 1 Replies View RelatedI'm trying to manipulate a large text file full of records (metadata - one complete record per line). I need to delete every line on which certain words appear - there are five different words, all pretty simple all-caps strings with occasional whitespace. I tried using grep -v, which worked a treat, but only string-by-string. Ideally I'd like to run this as grep -v -f, where the file targeted by the -f contains the strings I need to match in order to delete the lines they're in.
i.e. grep -v -f filecontainingSTRINGS.txt targetfile.txt > outputfile.txt
When I try this, however, I don't get any matches - or more specifically, no changes are made in the output file. It works fine if there's only one string in filecontainingSTRINGS, but it doesn't work if there's more than one (I'm using newline as the delimiter). (Also my machine doesn't recognise /usr/xpg4/bin/grep - no idea what that's all about!)
EDIT1: I should note that I was trying to do this in PERL, not sure if other alternatives are more simple?EDIT2: I should note that for text file 3 (reference), it's a long list of MANY cnp_id values and their corresponoding chr, start, and end values. So, the code will have to take the cnp_id from text file 1 and/or 2 and search through textfile 3 (reference) to match on the cnp_id and then take the corresponding chr, start, and end values and add to the relevant line in the output.EDIT3: Sorry, I should mention that the text file entries are all tab-delimited.I have 3 text files:File 1:Columns represent sample IDs (sample_id) and rows represent CNP IDs (cnp_id). Cells represents the confidence level (confidence) for each sample and CNP.Quote:
cnp_idP5E6_SNP6.0_JHP5_010408.CELP5E11reh_SNP6.0_JHP5_011808.CELP7C7_SNP6.0_JHP7_021208.CEL ... etc.
CNP100.0044798340.0027929510.00305613
[code]...
I have been running one computer with Fedora 9 and one with Windows XP Pro. to conserve space, I have moved the Fedora hard drive into the Windows computer (newer). Both are sata drives and each boots completely on its on. I would really like to make it a dual boot system so I can choose which drive to boot without having to open the case and swap the cables around. The Linux disk is readable by the windows OS but not the other way.
Everything I have read about dual-boot is how to do it at installation time. Is there anyway to do it, without reinstalling one of the OS.
Is there any software that will allow me to combine like DVD Shrink does? Without having to convert them muliple times. In DVD Shrink, you open one titleset and choose the movie you want and then open the second titleset and then do the same, and have DVD Shrink combine and shrink them into another titleset, then I make a menu with Titlewriter.
View 4 Replies View RelatedI've tried several methods without success. These OGV files are 7 parts of a single screen cast. I tried ffmpeg but every option I try I either get crappy video or the audio/video is out of sync. Latest attempt was:
Code:
ffmpeg -v 9 -i XDF_Demo-PART-0-video.ogg -r 15 frames-part1/XDF_Demo_%06d.png
But that failed because the png quality. mplayer and mencoder I mostly just couldn't get it to play the files together. easy way to combined these files so media players and html5 can play it in one pass?
I have a folder with only 24 files named <number>.dat (i.e. 4.dat, 6.dat and so on) where <number> is between 0 and 256. Each file has just two columns of data and nothing else.
I'm trying to combine all the second columns ($2) together. I've been fiddling around with getline and so far have
awk '{ getline ln < "6.dat" ; print ln" "$2 }' 4.dat
which takes file 4.dat and adds $2 from 6.dat, but I want a single command to take each $2 from every file and add them to (for example) 4.dat (having $1 from 4.dat is no problem). A command that takes every file in the folder and grabs $2 and places them in a common file would be ideal. Frankly I can work around if you combine both columns from every file.
I use vncviewer (win32) to connect to my SuSE 11.3 box. The SuSE box has the "standard" xinetd started Xvnc server running (includes the -inetd switch).
My client (the vncviewer) has to go through a firewall with limited ports available and so I use the command line:
Code:
However, if there is a problem with the connection, such that the client disconnects, it seems that subsequent request to the Xvnc server create a new session/display. The text in the client window reports "nobody's x11 desktop (host:1)", then "...(host:2)", then "...(host:3)" etc.
I have tried combining the display and the port parameters, like this:
Code:
Can anyone suggest an alternative way of reconnecting to a broken vnc session?
So I asked around and to combine audio files apparently I want to use Audacity.
It seems easy enough to LAYER audio files, but how do you string them together in sequence? I have an audiobook divided into 5 minute chapters and I want to combine them into longer chapters....my MP3 player likes to play them out of order which makes them difficult to listen to. I want to make it 1 long tract, or maybe 6 medium length tracks.
How do I combine tracks with Audacity...Not layering them but putting them in order into 1 long track?
I have 4 interfaces, dvb0_0 - dvb0_3. Each one has a multicast stream coming in on it. The program I am using to decode these streams only accepts one interface though. How can I "combine" so that the program, listening on 1 ip can get all 4 streams? they are on groups 224.0.1.1-4
View 1 Replies View RelatedSo what I am looking to do is combine an archive and a script file. I would like to have a number of files compressed into an archive package and when a user double clicks on the package instead of having it open with the archive manager, instead have it run a shell script that is also packaged with the files.
This shell script will do a number of things including handling where the files are extracted to. Over all this would be similair to a self-extracting installer Windows users are used to using.
I have window 7, Ubuntu and Cent Os installed in my system. I was actually trying to change boots options but unfortunatly i lost all boot entries. Is there anyway i can recover all three boot records.
View 7 Replies View RelatedI'm looking for a program of some kind that I can combine 4 (if not 2 minimum) streams of video into one file. The only program so far that I've found that does this is avisynth but I can't seem to make it work at all. Does it even work under ubuntu? I've tried numerous guides and how to's but nothing seems to be working.
Basically I just need something that will take a video file, from several different sources (cameras placed around a car) and be able to place them in a grid form into one file. Basically in a format like this, where each letter is a different video file:
a b
c d
I have a command which on the command line needs to look like this
rlam -if3 '!pvalue -H image1.jpg' > image2.jpg
Nevermind what rlam or pvalue do ... they are part of a program package I am using. The above command works on the command line, and also when written verbatim in a bash shell script.
My problem is: in the script I wish to replace image1.jpg with the content of a variable, e.g.
IM1=image1.jpg
How to I get the script to insert the value of $IM into the command when the pvalue part of it needs to be quoted?
I tried the Linux-based live CD's of the main Windows anti-virus vendors (Kaspersky, BitDefender, AVG, Avira). They work well, but they are single-purpose solutions while affected Windows users also need a solution to 1) pull data (or what's left of it) out of their contaminated Windows host onto a USB thumb drive or a remote host, and 2) restore a clean image using eg. CloneZilla. Asking users to burn and run three different CD's is not very user-friendly. Has someone already investigated combining those three features into a single live CD?
View 8 Replies View RelatedI want a video editing software for combining two videos at frame level. I mean, for eg: to show double action at a time in movie. We shoot two characters separately. And then we combine it
View 1 Replies View Relatedi want to configure a cluster for combining CPU / RAM / Hard disk
View 3 Replies View RelatedI want a video editing software for combining two videos at frame level. I mean, for eg: to show double action at a time in movie. We shoot two characters separately. And then we combine it as a single video with dual role effect. Now, I think you understood my requirement. Plz anyone tell that type of application which suits my needs.
View 3 Replies View RelatedI just tried to record a CD (standard data cd) with Brasero first and then with GnomeBaker and it failed both times right as it started to write with following error:
Code:
The errorlog from GnomeBaker says:
Code:
I already tried without burnfree but that didn't help either. Anyone know what the problem might be. It might be that the cdwriter is defective as I never tried it before (pretty new Dell workstation) but somehow I don't think so.
I have a sitution that I am trying to set up.
I have 2 email servers that run on Windows: one is for internal purposes, the other is external purposes.
The external one will receive e-mail from the outside world, clean it up and forward it to the internal one.
There are 2 Windows Vista machines and 2 Unix (OpenSuse Linux) machines.
Since there can be only 1 email server per domain, I thought I would:
-> set up a local domain with ALL of the machines in it
-> set up a DNS server for the local domain
-> set up a MX record in the DNS server for the email
For the external machine, just have a Dynamic IP point to the Windows machine holding the external email server.
Does this sound plausible? Does this make sense?