Ubuntu :: Combine Columns In Text Files?
Feb 15, 2010I have two files which I would like to combine. Each file has 2 columns.
File 1:
1 a
2 b
[code]...
I have two files which I would like to combine. Each file has 2 columns.
File 1:
1 a
2 b
[code]...
Combine multiple text files into one text file?
View 5 Replies View RelatedI need to overwrite the first say 50 or so lines of an xml file on an everyday basis. The first 50 lines of the file are always the same and the 50 lines they get replaced with are always the same. Is there a way to create a file with the 50 new lines and somehow copy/merge/overwrite the larger file such that the 50 original lines would be replaced but the remainder of the file would be untouched?This seems simple, there has to be a way to do it. I'm just not smart enough to figure it out.
View 2 Replies View RelatedThis solution works but is slow with large files. I am looking for a faster solution.
The 2 files contain filenames, one of them has associated data I want to append to the other file's matching filenames
file1:
file2:
I append file2 by matching the unique_filenames and appending them with the tag data and some formatting
appended file2:
Here is the SLOW code
while read inputline.
I have an audiobook in 64 small mp3 files and I need them combined into a single file of any format in the proper order or order that I add them in. What program can I use?
View 9 Replies View RelatedHow to use ffmpeg or memcoder to join two .ogv files into a single .ogv ??Let's suppose the first .ogv video file is named as "01.ogv" and the resolution is 800*600;the second .ogv video file is named as "02.ogv" and the resolution is 720*576.I'd love to join two video files into a whole one, with the resolution 320*240.
View 1 Replies View RelatedI have 2 text files : file1.txt and file2.txt
cat file1.txt
15 this is a sentence containing various words and spaces
34 this is a another sentence containing various words and spaces
cat file2.txt
2 this is sentence1file2
6 this is sentence2file2
54 this is sentence3file2
I would like to join these 2 files. The result should look as follows :
cat joinedfile.txt
2 this is sentence1file2
6 this is sentence2file2
15 this is a sentence containing various words and spaces
34 this is a another sentence containing various words and spaces
54 this is sentence3file2
==> so the joined file must be sorted on the first number. Any ideas how this can be achieved ?
I have three files with the following structure:
file1
1 2 3 4
5 6 7 8
[code]...
My backup script generates 2 lengthy log file. They have the same name, but the date is appended. I want to select the oldest one, condense it with "head" and "tail" and then append the condensed version of the newer one. They seem to get tangled up.Code:
ls `find . -iname "bak-log_*"` -1t | tail -1
and
ls `find . -iname "bak-log_*"` -rt | tail -1
[code]...
I have two files: one is like
preface
Introduction
chapter 1
the other is like
1
2
3
I was wondering how to column-wise combine the two files into one:
preface 1
Introduction 2
chapter 1 3
by using some utilities, such as awk, sed, available in Ubuntu?
I'd like to extract a single column from 5 different files and put them gether in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is:awk 'NR==FNR{a[NR]=$2; next} {print a[FNR], $2}' file1 file2I added the file3, file4 and file5 at the end, but it doesn't work. Does anyone know what do I have to do?
View 5 Replies View RelatedI want to merge columns (selectively) from several files and create a new file with the merge output. I saw some suggestions to use pr/paste to join the columns and then awk to pick-up the columns.
Code:
pr -m -t -s file1 file2 | gawk '{print $4,$5,$6,$1}'
But I have hundreds of files and I cannot manually pick up columns using awk as given in
[code]....
I've been hitting my head against a wall for awhile with this one:As the last part of some data analysis I performing I would to construct a matrix from a series of different files. These files have the format:
file 1 file 2 file 3
AAAAA .1 AAAAA .1 BBBBB .1
BBBBB .2 BBBBB .1 CCCCC .9
[code]...
How can I join the two parts of a stereoscopic movie to get a side-by-side one?
I can expand the left file, that way all I'll need is to paste the second one on top of it, with something like this:
mencoder left-file.mkv -o side-by-side.avi -oac copy -ovc lavc -of avi -vf scale=1280:720,expand=-1280:0:0:0 -sws 3 -lavcopts vbitrate=16000
Any idea which tool should I use on a Linux system?
I have hundreds of files in one directory, is there a simple command or pipes of command I can use to append them together? I don't want to use any loops.
View 4 Replies View RelatedI have 2 very long files which are quite similar:
file1.csv:
Code:
file2.csv:
Code:
I need this output:
Code:
explanation:
If the fields 3 (serie) and 4 (modello) are identical, the lines of the 2 files should be "added":
Code:
If the fields 3 (serie) and 4 (modello) are different, just print the line of both files:
Code:
Is there a way to do this without reading the (huge) files with a "while read line" loop?
I am working on a script that allows me to convert an IP address to a country name. I have 2 files. One that has text like: PORT.80 TCP SRC=x.x.x.x and the other is x.x.x.x United States. How can I combine these files so that the file output is PORT.80 TCP SRC=x.x.x.x United States?
View 5 Replies View RelatedCan I use sed to include a text file in the beginning of other text files inside a folder and its subfolders? So it should be recursive.
View 4 Replies View RelatedI would like to write a text user interface (TUI) to adjust some text config files etc. Is there a tool or application for creating TUIs like this. I�m talking about those types of config tools which you see executed at first boot.
View 19 Replies View Relatedmay be an advanced question but I need to know how to do this. Here at work I am in charge of recruiting and we have about 1,000 resumes in already. All of the resumes are in a .pdf format. I need to rename every .pdf in the following format:{firstnameLastname}.pdfThe only way I know how to do this is to convert all the .pdf files to text, extract the name out of the first few lines of text, import into excel, and then use VBA to rename the files in mass:Here is my logic so far:~Deskop/a = houses all the .pdfresumesOpen terminal: Code: cd ~/Desktop/afor f in *.pdf; do pdftotext -raw $f; done That will convert all of the preceding resumes into text filesNow I would like to append the name of the text file into the last line of the text file. So, for example, for Resume1.txt, I want to append "Resume1.txt" to the last line within Resume1.txt. So after I run the command I open Resume1.txt and on the last line within I want to see "Resume1.txt" on the last line, at the end of the resume.How can I do this? I would like to use a loop and have the terminal append the filename to the body of the text file until all of the have been appended.
View 1 Replies View RelatedCurrently, when I'm searching text in files of my PHP project, I use this line :
Code:
grep -r 'myTextToFind' *
But now, I would like to search only in ".lang" files. How can I do that ?
Is there any Linux utility to combine two or more binary files into a single binary file ?
View 7 Replies View RelatedI found this command that works great finding and replacing a simple string to another in files located in that folder and all sub-folders.
Code: find . -name '*.php' | xargs perl -pi -e 's/OldText/NewText/g'
The problem I have is that I need to replace a more complex string, like this: Old string: /mnt/stor6-wc2-dfw1/627896/982574/ New string: /mnt/stor8-wc2-dfw1/369587/302589/ There I don't know how to do it... since the / is what separates the old from the new strings, and the strings that I want to replace have / in it. Also, I would like to know how to specify under what folder replace the files, for example, I want that it search/replaces all files under /var/www/mysite/htdocs folder.
I want to automate this using script.How to automate it?
File1:
s.no# 1 name:aaaaaa
city:abcd
[code]...
Fedora provides several compression techniques. E.g tar, tar.gz, zip etc. I want to know which among them provides
1. the best compression ratio for text files
2. the best compression ratio for binary files
3. fastest compression
How do you convert Open Office (ODT) documents to Text files?
I have made a report using libre office. Now I wish to continue editing the document using lyx (latex front end). So the ODT file needs to be saved as some .tex file.
I don't see an option to do this in File menu (export/save as). So is there any other plugin to do this?
How can I compare two pdf files for text differences
View 3 Replies View RelatedA real os should at least e able to read and write plain text, you think? But no, when I try to open my text files (mainly made with gedit) some characters are ass, swedish letters rarely work and ', ", / and so on are not represented as the characters I want to see. Is there a easy, fast way to read (and print!) my text files at school, where they have only windows, without spending half an hour fixing the file by hand?
View 6 Replies View RelatedI need to view 10.858 text files by this friday to see which ones I need (searching file contents is not a solution), I was wondering if anyone knew any way/program to quickly view them as if they were, for example, images? And, optionally, to be able to save them to a different location from there? It doesn't necessarily have to be for Ubuntu as I also have WinXP and Vista, but it would save me having to transfer those couple of gigabytes to another computer.
View 3 Replies View RelatedSo I have Python file :
Code:
#!/usr/bin/env python
print 'python'
raw_input('')
And another :
[Code]....
as it should. I don't want to take such a hassle always running python by path.