Command line utility to join lines of two files

learn more… | top users | synonyms

-2
votes
1answer
47 views

Join some files in bash

I have a task. I have to join files A:B.dsv, B:D.dsv and N:A.dsv. Column are separated by ':'. And I have to join by relation N:D. And sort end file by D. A:B.dsv: R0X 7M3:48B56 L6R 5X3:08P68 E1W ...
0
votes
1answer
25 views

join - file is on sorted

I tried join two files, but I don't know why join doesn't listen to me. File i: 1 afjsadfjasdf 3 afdadsfa 4 afjdsakjfads 5 asdfadsfads 9 asfadsfads File k: 1 fdasdfadsfads 2 dfasjfadsjfas 3 ...
1
vote
0answers
73 views

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 ...
0
votes
0answers
60 views

Did I setup Active Directory on my server correctly? (re: Linux/OSX can't join domain)

I've just installed Active Directory on my Windows 2012 R2 server and my Windows 8/10 machines connect perfectly, but Linux and OSX can't seem to connect. The AD server's computer name is "DC01" and ...
0
votes
0answers
18 views

Simple way to join two / thee / four networks and share resources?

We have two domestic networks, each with it's own ISP, Netgear N600 wireless router, Synology server and assorted PC's, netbooks, laptops, printers. etc. Each has a static IP address so that the ...
0
votes
0answers
82 views

Join two matroska videos without re-encoding

I have two videos in mkv format, one 50mb (2 minute) and the other 1.4 Gb(2hr 23 min). I'd like to just join the two without going through a 30 hr long encoding process. Is there a way? PS: I tried ...
0
votes
2answers
55 views

Sort on ID, then sort on date, then remove lines which have the older date?

I have a couple of tab delimited files. Each file is structured like so: ID Title Rating Date_Rated What I want to do is merge all these files into one, ...
0
votes
2answers
292 views

join 2 video file by command or code

i already use ffmpeg to join 2 files but there is some problem, second videos maybe have different dimension so get some error while converting : Command : ffmpeg -i introlq.mp4 -i lq1.mp4 ...
2
votes
1answer
83 views

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 ...
2
votes
0answers
93 views

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 ...
0
votes
1answer
312 views

Using SQL to join spreadsheets in excel

Based on the explanation here: How do I join two worksheets in Excel as I would in SQL? I tried to join two excel sheets from different files into the same sheet. However, I keep getting this error ...
-1
votes
1answer
44 views

Would shell command join cause out of memory?

I have two file to join. FILE 1: a A1 a A2 a A3 ... c C1 c C2 ... FILE 2: a feature1_of_a a feature2_of_a ... a featureN_of_a ... ... c feature1_of_c c feature2_of_c ... after join, i ...
16
votes
5answers
20k views

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 ...
2
votes
2answers
115 views

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. ...
1
vote
2answers
782 views

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 ...
7
votes
6answers
1k views

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. ...
4
votes
5answers
5k views

How to join MP3 files? [duplicate]

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 ...