Command line utility to join lines of two files
join is a command line utility to join lines of two files.
Questions tagged [join]
42 questions
48
votes
7 answers
Join mp4 files in linux
I want to join two mp4 files to create a single one. The video streams are encoded in h264 and the audio in aac. I can not re-encode the videos to another format due to computational reasons. Also, I cannot use any GUI programs, all processing must…
Jose Armando
- 481
7
votes
5 answers
How to join MP3 files?
Motivation
I'm looking for a program that allows me to join a lot of mp3 files (an audio book) to a single large mp3 file. My mp3 player is able to remember the position inside a track, but it takes a while to reorganize the database if there are…
tangens
- 1,880
7
votes
6 answers
Joining text files with 600M+ lines
I have two files, huge.txt and small.txt. huge.txt has around 600M rows and it's 14 GB. Each line has four space separated words (tokens) and finally another space separated column with a number. small.txt has 150K rows with a size of ~3M, a space…
dnkb
- 387
4
votes
0 answers
Is it possible to find piece of audio inside of mp3 file?
We have a community radio and we are recording all shows 24/7. And we are wondering is there any way to automatically trim those recordings so that all commercials and unwanted parts are cutted off and rest of the show is joined ex. 1hour .mp3 file?…
Godspeed
- 41
3
votes
0 answers
How to join 2 WAV files that overlap?
I have several WAV files that overlap a couple of seconds, concretely the first 6 or 7 seconds of one are the same as last of the previous.
I'd like to join all of the chunks in just one file but taking care of the overlapping so that there are no…
James Russell
- 299
3
votes
1 answer
joining lines while adding white-spaces to select strings in CMD does not always work
here is an ordinary .bat that joins all lines and leaves a whitespace between the resulting strings.
@echo off
setlocal EnableDelayedExpansion
set row=
@For /F "EOL=|" %%x In ('^""%__AppDir__%find.exe" "."^<"%userprofile%\i.txt"^"') Do @Set…
Elisha Habinsky
- 185
3
votes
1 answer
Shell command 'Join' not working
I am joining two very simple sorted files but for some strange reason it is not working.
f1.txt:
f1 abc
f2 mno
f3 pqr
f2.txt:
abc a1
mno a2
pqr a3
Command:
join -t '\t' f1.txt f2.txt -1 2 -2 1 > f3.txt
FYI in the f1,f2 files the space is a…
2
votes
0 answers
Bash sort and join problems
I have to join two files. Firstly, I use commant sort and made two new sorted files. Next I use join, but it doesn't work.
My script:
sort -t ',' -r -k 4,4 file1.csv > sortf1.csv
sort -t ',' -r -k 1,1 file2.csv > sortf2.csv
join -t ',' -1 4 -2 1…
diego9403
- 917
2
votes
1 answer
Join files in the cloud
I have a Dropbox/One Drive/Google Drive account. I also have a very large file to be uploaded (12GB). My internet connectivity is limited, so I will not be able to upload the file in one go. Is there any method by which I can split the file in my PC…
Mani A C
- 21
2
votes
2 answers
How to print separator for all fields in join utility?
For example:
file a:
Tom:black
Lily:pink
file b:
Tom:big
Kate:small
And, the result:
join -t: a1 a b
Got:
Tom:black:big
Lily:pink
But what I want is:
Tom:black:big
Lily::pink
i.e. The colon in the last line is missing, any idea?
Lenik
- 18,830
2
votes
2 answers
Join with gzipped files
I want to use the command line join utility on two files. Unfortunately, they're gzipped. Because they're both gzipped, I can't use gzip -cd. Is there a slick way to do this without having to unzip them?
pythonic metaphor
- 2,436
2
votes
2 answers
Merging Multiple files based on the common column
I have multiple files, each with two columns :
For example :
file1.txt
ID Value1
1 40
2 30
3 70
file2.txt
ID Value2
3 50
4 70
9 20
And so on,
file1230.txt
ID Value150
9 98
10 52
2 71
How do I merge these files based on the…
user1083096
- 23
- 1
- 4
1
vote
2 answers
How to join lines between line spaces in notepad++
Is there a way to join lines between new lines (return), and keep the new line (return)? Been doing it with Ctrl+J after selecting the text between the new lines, but not practical with large documents.
Something to transform text from:
Mary had a…
mr_kultist
- 11
1
vote
2 answers
How to concatenate cell with the Amount and cell with Currency Code?
This keeps bugging me, I've checked various Excel forums but it seems this is either a trivial problem (an I'm an idiot) or this simply wasn't asked before:
Let's say I have two columns with data column A contains ISO currency codes, like EUR, GBP,…
1
vote
1 answer
How To Prevent Apps on macOS from Moving Themselves to the Applications Folder?
Some apps, like "Skype Meetings App" and "Join.me" surrepticiously copy themselves to your applications folder without asking or even so much as a notification.
How can this be prevented?
Isn't this a fairly large security hole in macOS... What…
Cerniuk
- 141