Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [concatenation]

The tag has no usage guidance.

0
votes
1answer
40 views

Is there a way to tell ffmpeg “encode file A with format settings of file B?”

I know I could use ffprobe and then parse the text file to get the codec info of file B, but is there a simpler way? Goal: I want to append a few seconds of silence to hundreds of audio files (who ...
2
votes
2answers
47 views

Multiple Search Formula in Excel [duplicate]

I am trying to find a formula which will search one cell for specific words. I would like the outcome of the formula to be words I have selected. The example of this I have is if one cell shows the ...
2
votes
1answer
253 views

Wrong string concatenation using Bash Windows Subsystem

I'm having headaches to know why my script doesn't work as expected under windows subsystem linux. My version from the store : Debian GNU/Linux 9.6 (stretch) (I tried ubuntu too, with the same ...
-1
votes
0answers
66 views

ffmpeg concat ts files including subtitles

I am encoding with ffmpeg. What I'm doing right now is to split it into a ts file and then paste it back to the mp4 file via the concat option. But the problem is that there is a subtitles in this ...
0
votes
0answers
30 views

Microsoft Excel: string concatenation truncated when output copied (using & operator)

I have a cell which joins the contents of a few hundred other cells (strings) using the & operator. It begins with: =C2&CHAR(10)&CHAR(10)&C4&A36&C36&D36&C5&CHAR(10)...
0
votes
2answers
48 views

How to step up cell reference in function by numeric values based on known number of rows

This is in reference to the formula I need for cell F2 in the below image. F2 shows the result I WANT: I NEED: The Concat Formula to concatenate the data in Column B for each variant of whatever is ...
0
votes
1answer
76 views

Minimal CPU and memory usage during concatenation, future advice need

I'm joining two 4K Prores422 HQ MOV files, a short spot (1GB) and a feature film (220GB). My current fps is around 9.0 and according to activity monitor my CPU usage is at 0.34% and only 5GB memory ...
1
vote
1answer
147 views

Crossfade many audio files into one with FFmpeg?

Using FFmpeg, I am trying to combine many audio files into one long one, with a crossfade between each of them. To keep the numbers simple, let's say I have 10 input files, each 5 minutes, and I want ...
1
vote
2answers
25 views

Conditional Concatenate inserting or not inserting underscores depending on cell value

I'm a beginner on excel and I'm trying to get the following result: Col1 Col2 Col3 Col4 John Jim Tom Sarah Ann Betty blank blank Lee Sue George blank What I ...
0
votes
0answers
40 views

Convert video file using format from another file

To eliminate XY problem, here is what's my situation. I have source YouTube videos in MP4 container. I create voiceovers for them using Sony Vegas on Windows machine and then export them as WAV file, ...
0
votes
0answers
78 views

concat two videos including subtitles

I have two video files (mkv) each with one video stream, two audio streams and four subtitle streams. Now I'm using ffmpeg to concat these two videos. I'm using filter_complex with concat to do this. ...
0
votes
1answer
170 views

ffmpeg becomes super slow when using duration instead of -r

What I'm doing: I'm still working on my slideshow script. Meaning, I use ffmpeg's concat demuxer (files.txt) to provide ffmpeg with a bunch of .jpg files for a slideshow. In the past I wanted all ...
1
vote
1answer
78 views

Is it possible to burn a filename watermark in the corner of a concatenated image slideshow and have it change for each image?

What I want to do: I have a folder with a great bunch of images. Using these files I want to create a slideshow video, while I want the filename of each of the original images burned into the bottom ...
0
votes
1answer
58 views

concatenating videos with different parameters

I'm trying to concatenate 3 videos, which have different encodings, and 2 lack audio. I added mute audio tracks to the ones that didn't have any using: ffmpeg -i video1_no_audio.m4v -f lavfi -i ...
0
votes
1answer
40 views

Merging Mp3 files and keeping indices

I have multiple Mp3 files: 0001.mp3 0002.mp3 ........ 9999.mp3 Each file has its own size/length which is different from the others. I want to merge them into a single Mp3 file. In the same time ...
1
vote
1answer
115 views

FFMPEG Concat Silence & 10 Channel WAV

I am trying to join together using concat some silence which is generated, and then a WAV file. This works fine when the WAV is mono, stereo, etc. - but goes wrong when we have 10 channels of audio; ...
0
votes
0answers
24 views

Combining two columns to other two columns, sharing same first column data but not sharing all rows data in Excel

How to join the data of two columns to another two columns, they both have the same first column name, but they dont share all the same rows data in Excel. The rows are not so litte, to do that ...
0
votes
3answers
2k views

How to add contents of multiple rows into one cell, grouping by a third row in Excel 2010

I'm trying to get multiple names from different rows into one cell in one row, but group it by a value in another column. I also need the list of names to have line breaks between them, not a comma ...
0
votes
2answers
101 views

Concatenate a massive number of small PDFs quickly

I'm on Windows 10. I have 2,000 PDF files, each has two or three pages (with exactly one page blank) and is only 40~50 KiB in size, summing up to less than 100 MiB. I want to concatenate all pages in ...
1
vote
2answers
71 views

Build a string randomly, not repeating

I cannot seem to find a way to do this. I have five cells in excel. I want to concatenate them into a string randomly. I want to use each cell character once in the string I am building, so I end up ...
0
votes
2answers
1k views

Concatenated cells return random number instead of date

I have a question about an excel formula. I have a some fields I want to concatenate together. One of those is a date made with the formula TODAY. When I concatenate all together it will give me a ...
1
vote
1answer
932 views

Can't concatenate a string inside a batch loop

I've been struggling with this for a while now, and I can't seem to figure out why. I have this batch file: @echo on setlocal enabledelayedexpansion for /F %%x in (FileList.txt) do ( for /L ...
2
votes
1answer
411 views

FFmpeg concat mp4 corruption

When I run ffmpeg -f concat -i resizedvideolist.txt -c copy concatenated_time.mp4 2>&1 it concatenates all the videos in the txt, but there is one video around halfway through that get ...
0
votes
1answer
92 views

Concatenate two videos and one picture

I have 1 picture (png) and 2 videos (mp4). Using Windows OS, I need to concatenate their: video + picture duration 5 seconds without sound + video. How can I do it?
1
vote
1answer
78 views

Concatenate 2 cells from Sheet1 to 1 cell Sheet2

EDIT: Found the stray code that threw it off. Thanks everyone! I've been trying to figure out the code to concatenate Worksheets("Sheet1").Range ("B2:C2") to this reference cell with " - " ...
0
votes
1answer
959 views

FFmpeg: concatenation without reencoding

I have two *.mpg files. I'd like to concatenate them by picking the video stream (MPEG-2) and the MP2 audio stream. My problem is that the streams are always reencoded. I'd like to avoid this, but I'm ...
0
votes
3answers
682 views

Need Excel CONCATENATE formula [duplicate]

I need help with a CONCATENATE formula that has quotes. I need it to add this to the cell. appcmd set site /site.name:"YOURWEBSITE.COM" /-bindings.[protocol='https',bindingInformation='*:443:XYZXYZ'] ...
0
votes
1answer
2k views

Combine the Sumif function with concatenate [closed]

Is there a way to concatenate a string of text cells if, lets say, the value above each cell is "yes"? For example: yes yes dog cat bird hen In this case, the concatenated ...
0
votes
1answer
630 views

In Excel, why does PERCENTAGE format display change when adding a PERIOD “.” on the IF/VLOOKUP formula?

I'm using MS Excel 2016. I’m using this formula: =IF(D8="","XX.XX%.",VLOOKUP(D8,P:Q,2,FALSE)) to display 12.34%, which is exactly how it appears on the source cell. However, as soon as I concatenate ...
3
votes
1answer
1k views

FFmpeg concatenate audio and offset parts between each other

I figured out how I can concatenate multiple audio files with complex filter, but struggling with offsetting audio in result file. Say, I want to add a gap of 1 seconds silence between each ...
0
votes
0answers
27 views

Video concatenation excruciatingly slow

I tried using OpenShot Video Editor to concatenate a few videos of a vacation I recently went on. However, the process seems to be taking forever; I really do not want to leave the computer on all day....
0
votes
0answers
16 views

Editing a video

I used OpenShot Video Editor to concatenate a few videos of a vacation I recently went on. However, the first 18 seconds of the video is upside down; the rest of it is fine. Even though I am using ...
0
votes
1answer
178 views

Strange behaviour when sorting IP addresses. (sort -nu)

I just tried to |sort -nu (numeric & unique) a list of ~30 or so IP addresses and noticed that in addition to culling duplicate lines, it's treating similar lines (i.e. addresses with the same ...
0
votes
0answers
38 views

Make words fat using function bar

Is there a way in MS Excel 2013 to format words fat/thick using the function bar? I need the concatenating function and want to highlight each cells information with an additional section like title ...
14
votes
1answer
16k views

FFMpeg concat demuxer unsafe file name

I'm using ffmpeg inside my .net application to merge(concatenate) some short videos with the same encoding and width and height dimensions. I've created a txt file as the documentation says and this ...
0
votes
1answer
78 views

Concatenate multiple columns - formula issue with two columns?

Am trying to merge four columns of numbers with hyphens between; have done it before, but this time as soon as i get to the third column (S2) the formula turns purple as if there is an error. have ...
0
votes
1answer
58 views

Trouble removing null fields and delimiter while concatenating in access select query

I am relatively brand new to Access (using 2013). I'm linking my query to Excel which is working fine. I had a concat function that I probably got from this site but Excel didn't like linking with an ...
0
votes
2answers
790 views

Concatenate audio files

I tried three different methods in order to concatenate songs Audacity: Works, but it adds a "click" sound between the first and second song cat command: I tried cat *.wma > result.wma and cat ...
0
votes
1answer
734 views

FFmpeg – Concatenating multiple MP4 files

I am using an external script (http://trac.ffmpeg.org/wiki/Concatenate#extscript) to concatenate multiple MP4 files. This script lets you do a command like this: ./mmcat input1 input2 input3 ... ...
0
votes
1answer
80 views

trying to concatenate commands to give a file path

I'm trying to concatenate several commands to give a file path. I need to run this: ls -l /proc/{PID}/fd/{FILE_NAME} I can get the PID by running: lsof | grep 'mysql\(.*\)deleted' | awk { print $2 ...
1
vote
1answer
581 views

Flatten/Concatenate an array to a list for match in excel formula

I have a table of data in excel which has double header rows. I would like to perform an hlookup against this table using a flattened version of the two headers. For example, if my data were like ...
3
votes
1answer
90 views

concatenate files from different subdirectories

I have many subfolders from my current operating directory. In each subfolder, there is a file called "total" "total" contains 2 columns of data, and remember there are many "total" files, each in ...
0
votes
1answer
976 views

how to concatenate the output of vlookups in one step

I'm trying to run two vlookup operations and concatenate the results in one formula as such: =CONCATENATE( VLOOKUP($A$6,'TRP'!$A$7:$D$655,2,FALSE), "/", VLOOKUP($A$6,'HCP'!A5:B655,2,FALSE) ) The ...
2
votes
1answer
722 views

FFMpeg can't concat certain videos

I have some videos recorded with my android phone. They are quite similar. For instance: original0.mp4 original1.mp4 original2.mp4 (this one is broken) I apply this filter to each of them: ffmpeg -...
1
vote
1answer
9k views

Powershell string concatenation of expressions

I'm using a ternary expression as shown in this example: $a = 1 $x = if ($a -eq 1) { "one" } else {"not one" } $t = "The answer is: " + $x write-host $t This works as I would expect. What I would ...
0
votes
1answer
404 views

Concatenate four binary files using alternating pattern in Linux

I need to concatenate four binary, meaning non-text files. Lets say I have four files: file1: AAAA file2: BBBB file3: CCCC file4: DDDD Now I want my resulting file to look like: ABCDABCDABCDABCD. ...
0
votes
2answers
8k views

Concatenate multiple files with Windows command line

I use below two commands to concatenate multiple files from different directories: Method 1 type "C:\folder1\file1.txt" "C:\folder2\file2.txt" > output.txt Method 2 copy "C:\folder1\file1.txt"+"C:\...
1
vote
2answers
73 views

Concatenate files in order with type

I am trying to use this command: type *.dump > total in order to concatenate my .dump files into total. However, the numbering of concatenation is wrong. For instance the files in order are: ...
1
vote
0answers
133 views

Why concating two videos with ffmpeg (5s and 33s) produce 4m34s video in slow motion

I am developing a service to concat a video (mine) with a another from a user (he/she upload it) and return to user. First I tried to use Concat demuxer because I don't want to re-encode videos if it ...
1
vote
2answers
1k views

Concatenate csv-files with the same name from subdirectories

I found some scripts concatenating text files from different subdirectories, but all of them produced output files like "output.txt", but didn't keep the original file name. Structure Folder_A a....