Command line utility to join lines of two files

learn more… | top users | synonyms

1
vote
1answer
31 views

Stack Ranges into 1 Column

If I had two columns by 4 rows: A1 B1 A2 B2 A3 B3 A4 B4 I would like the result A1 A2 A3 A4 B1 B2 B3 B4 I've used choose function to combine different ranges before ... but it doesn't seem to like ...
-2
votes
3answers
69 views

trying to join my computers in a more efficient way

i know there have several answers about how to link 2 computers together so they can share processing power. this seems to be way beyond what i need and i was hoping someone with more hardware and ...
-2
votes
1answer
49 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
37 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
89 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
83 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
19 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
119 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
63 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
354 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
92 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
99 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
351 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 ...
19
votes
5answers
22k 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
828 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 ...