Questions tagged [concatenation]
The concatenation tag has no usage guidance.
184
questions
0
votes
1
answer
14
views
Trying to concatenate a row and variable columns
I'm trying to concatenate a static row and column data that is variable. In Column A1 is Job Roles. So in A2 the value is "Security Analyst", in A3 the value is "Security Engineer&...
- 1
0
votes
0
answers
459
views
FFMpeg Concat error: [mxf @xxx] index entry xxx+ TemporalOffset 1 = xxx, which is out of bounds
Use FFmpeg to concatenate broadcast files about 50 times a day.
Files are transcoded to XDCAMHD prior to being concatenated. This error occurs on 15% of all concats even if there is only 1 source file....
- 91
1
vote
1
answer
31
views
Conditional concatenation Excel 2003: if text TRUE, add asterisk
=CONCATENATE(A1)=IF(ISBLANK(F1),"","*")
If there is text in column F (not just a blank space), I want to add an asterisk to the value in column A. I only want to see TRUE for H3 ...
0
votes
0
answers
62
views
How does ffmpeg concatenate files that contain multiple streams with different codecs if codec=copy?
This is a general question that is best explained by an example:
Suppose I have two M2TS files, 1.m2ts and 2.m2ts. Each file contains a video stream with 23.976 f/s (actually 24000/1001 f/s, frame ...
- 1,785
0
votes
2
answers
88
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...
0
votes
0
answers
74
views
concatenate flac, opus, wav file parts with ffmpeg
I tried concatenating two flac files with this command:
ffmpeg -i 1.flac -i 2.flac -filter_complex '[0:0][1:0]concat=n=2:a=1[out]' -map '[out]' -c:a copy out.flac
i get the following error message:
...
- 95
1
vote
0
answers
111
views
ffmpeg prepend still image to video
Disclaimer: I am NOT proficient in video editing at all; this is almost my first attempt
so I could be missing something very basic. Please be lenient and redirect me to relevant
tutorials, if needed.
...
- 541
0
votes
1
answer
36
views
Part of string missing while concatenating 2 string variables
I am using Bash version 5.0.17 on Ubuntu.
I am trying to append a date and time (based on the file's modified date) to a filename for backup purposes.
I create the substring to append by doing the ...
0
votes
1
answer
195
views
ffmpeg concat without reencoding keeps audio in one order but not the other
So I took a video and cut it two ways, one with reencoding and one
without reencoding, call them R and C (cut). Im trying to do
concatenation without reencoding, and I'm able to concat the video in
...
-1
votes
1
answer
406
views
Trying to generate a listfile for ffmpeg concatenation via drag and drop onto a batch file
Yeah so pretty simple question really, theres only 3 steps to the process:
1. Get alphanumeric listing by dragging and dropping files.
2. Edit the file list to match the following syntax/layout:
file '...
- 19
0
votes
0
answers
180
views
FFMPEG Concat Demuxer adds more time to output than expected
I am using ffmpeg concat demuxer to join multiple(189) videos together. The videos are originally split from a single video using the following command:
ffmpeg -ss time[2] -vsync 1 -copyts -i ...
- 1
0
votes
0
answers
238
views
ffmpeg error Input link parameters do not match the corresponding output link parameters
I need to concatenate n mp4 videos of different resolutions via ffmpeg. However, I am receiving an error despite the fact that in the filter_complex before performing the concat operation I scale all ...
- 111
0
votes
0
answers
244
views
ffmpeg concat with filter eats up all memory
I have been trying to produce a indefinite loop of a list of videos in a folder. For testing purpose, I am using only 2 videos as input. I then concat them to produce an output of 1280X720 output.
...
1
vote
1
answer
217
views
ffmpeg cut, fade and concat causes the video to get stuck
I'm trying to add "fade out" effect to a long video. One method I explored is cutting video at the end before few seconds, adding the fade out effect to the second split and concat both the ...
0
votes
1
answer
72
views
ffmpeg concatenated audio not present in the output
I'm trying to concatenate two audio files and add it to a video file but the output does not contain the audio.
I can see the duration of the output video is the sum of the two audio. But the audio is ...
0
votes
0
answers
139
views
FFMPEG How To use Concat demuxer with a crossfade
I've got the concat demuxer to work well using this code: ffmpeg.exe -f concat -safe 0 -i videoList.txt -c copy output.mp4 where videoList.txt is a file containing this type of data:
file ...
1
vote
1
answer
35
views
I have a Text file that contains paths and filenames, I want open explorer to each one
I have a Text file that contains the following information:
X:\Mr.Wizard\Desktop\Calibration Instruction\CUP CALIBRATION.doc
X:\Mr.Wizard\Desktop\Document\Instruction\Variance.doc
For the life of me, ...
- 11
0
votes
1
answer
671
views
concat two videos with same format
I'm trying to concat two videos that have very similar formats :
Stream #0:0[0x1](und): Video: hevc (Main 10) (hev1 / 0x31766568), yuv420p10le(tv, bt709, progressive), 1920x1080 [SAR 1:1 DAR 16:9], ...
- 1
0
votes
1
answer
139
views
How to CONCAT (or something like it) Sheet-file path reference in Excel
I’m trying to simplify my Excel function my referencing a simple string I am using quite a few times.
In Sheet1 and Sheet2 and have a small matrix.
That I am calling from Sheet3 with the INDEX ...
- 263
0
votes
0
answers
46
views
How to have some form of concat/dynamic element in INDEX?
In Sheet 1 I have 1, 2, 3, 4 in A1:B2
so that I can Sheet 2 can call cell 4:4 by =INDEX(Sheet1!A1:B2;2;2),
Work's gerat! However, in Sheet 3 I have a table, identical to the one in sheet 1, that I ...
- 263
1
vote
1
answer
117
views
Why does ffmpeg quit before adding all requested frames to a clip?
I have a problem with using ffmpeg to collect .jpg files from security cameras and making .avis from them.
The cameras FTP in frames on a regular basis as fast as they can, accumulating some 16000 to ...
- 11
0
votes
2
answers
167
views
I have two cells each with comma delimited values, I want to combine these into one cell
I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...
- 1
0
votes
1
answer
148
views
FFMPEG 3 video Concat / Overlay
I have been getting to grips with FFMPEG for the last few days...so please excuse my lack of knowledge. It's very much early days.
I need to join 3 video elements together with one of the videos ...
- 1
0
votes
2
answers
183
views
How to concatenate multiple cells without typing each one and add a space after each value
I have a list of hashtags that I would like to use in my Instagram posts. I would like to make groupings of the hashtags so I can easily copy and paste them to my posts.
The hashtags are sorted by ...
- 963
0
votes
2
answers
124
views
Merging rows and concatenating one column's data
I have a report with four data columns (see attached rows 1-9). I'm trying to merge any cells that have the same ExpDate and AccountName, and have the Type include all data. I've seen examples where ...
0
votes
1
answer
1k
views
How to concatenate videos with different bitrates using ffmpeg
I want to concatenate two files having the following outputs from ffmpeg :
file1:
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'file1.mp4':
Metadata:
major_brand : isom
minor_version : 512
...
2
votes
1
answer
788
views
How can I losslessly concatenate two MP4 files and keep the telemetry information (GoPro GPMF) using FFmpeg?
One may losslessly concatenate two MP4 files using FFmpeg as follows:
ffmpeg -safe 0 -f concat -i list.txt -c copy output.mp4
with list.txt:
file 'C:\file1.mp4'
file 'C:\file2.mp4'
However, if the ...
- 21.3k
0
votes
2
answers
752
views
concatenate with ISBLANK and delimiter
I am attempting to combine two columns in Excel 2016, with a space between the results. My problem is being able to use ISBLANK to ignore blanks on either column, and still have the space delimiter in ...
0
votes
1
answer
141
views
How to condense data irregularly distributed over several rows in an Excel table
Actual Table: Data irregularly distributed over several rows and thus partially empty lines
Date
Text
Date_1
Text_1A
Text_1B
Date_3
Text_3A
Text_3B
Text_3C
Date_6
Text_6A
Text_6B
Date_8
...
- 3
0
votes
1
answer
559
views
FFmpeg concat messes up last frame of first segment
The Problem:
I routinely need to cleanly concatenate two .MKV files with ffmpeg. About 10-20% of the time, the last 3-5 frames of the first video segment has issues in various video players (VLC and ...
0
votes
1
answer
287
views
Merge 2 columns in Excel and make data permanent
I know how to concatenate 2 columns in Excel, but I want the new column to become merged data NOT dependent on the formula. The reason is I can't copy the results into a new column.
I.e.
|col 1 | ...
- 11
0
votes
0
answers
19
views
FFMPEG disjoin/separating/uncoupling of MP3 album file [duplicate]
I have an single MP3 album file that has when loaded in a player multiple tracks with artist and title.
In FFMPEG there is an option to concatenate media files. What I'm looking for is to split this ...
- 1
4
votes
2
answers
2k
views
Why do 1920x1080p videos still get stretched and distorted after I concat them?
I have several videos with different aspect ratios.
I use this command to put them all within a 1920x1080p frame:
ffmpeg -i input -vcodec libx264 -s 1920x1080 -r 30 -strict experimental output
This ...
- 43
0
votes
2
answers
318
views
Is there a way to make a =CONCATENATEIFS() in Excel
I have a table like below :
Person
Bank
Credit
Julius
HSBC
1000
Julius
BoA
200
Marcus
HSBC
500
Marcus
BoC
400
Kylie
BoA
800
I want to convert it to a table like that :
Person
Banks
Credit
...
- 145
2
votes
2
answers
2k
views
Merge .txt files in Specific Order
I have a set of 300 chapters named Chapter 1.txt, Chapter 2.txt... Chapter 300.txt]
The goal is to try to create a combined .txt file with all of these chapters in order.
Each file is formatted with ...
- 23
1
vote
0
answers
346
views
FFmpeg concat produces longer output compared to the combination of all segments
I have around 96 .aac files in a directory that I want combined to produce an output.aac file. Similarly, I have 96 .ts segments to pair with the audio file. The .ts files produce an output of 9 ...
- 11
0
votes
1
answer
378
views
How to concatenate leading zeros on linked cells?
Sheet A (customers)
Over 2,000 customer listed
07.001 is the first customer with the last name beginning with "G"
07.056 is the 56th customer with the last name beginning with "G"
...
1
vote
0
answers
152
views
Multiple Audio Trim with multiple channels of audio ffmpeg
I am looking for a way to trim a single video with 4 channels of audio in multiple places and then concat the pieces together maintaining the 4 audio channel trims as well.
I have the following ffmpeg ...
- 11
0
votes
1
answer
324
views
Invalid file index 14 in filtergraph description - FFMPEG
I am getting error in my command saying: Invalid file index 14 in filtergraph description
But I am seeing teh correct count and inputs. What indx I am doing wrong. Please can you advise me.
Below is ...
- 101
0
votes
1
answer
642
views
Getting an “Invalid argument” error when giving effects to multiple videos with FFmpeg
I am trying to give transition effects to multiple videos together in one command using FFMPEG. I am not able to find the issue. I have tried the command as advised at url: Merging multiple video ...
- 101
2
votes
1
answer
1k
views
Invalid file index 3 in filtergraph description -- FFMPEG
I am trying to concat 3 videos and give effetcs using FFMPEG. My below script is giving error.
I am not able to understand what is the issue. Which index i am missing.
Script below:
ffmpeg -i D:\...
- 101
1
vote
1
answer
561
views
Issue in Video when giving effects to multiple videos using FFMPEG
I am facing issue when giving effects to multiple video using FFMPEG using script below:
ffmpeg -i Episode10_2952.mp4 -i Episode10_3507.mp4 -i Episode10_RmvAdVi_1_5645.mp4 -i Episode10_RmvAdVi_1_9226....
- 101
2
votes
1
answer
2k
views
Cannot allocate memory - FFMPEG
While giving effects to multiple video using FFMPEG. I am getting error Error while filtering: Cannot allocate memoryme=00:06:02.98 bitrate= 676.0kbits/s dup=22 drop=0 speed=4.58x Failed to inject ...
- 101
0
votes
0
answers
780
views
FFMPEG Concatenate two files while keeping the duration the same as the two files separately
I am trying to concatenate 2 files. But When I calculate the duration of each individual input files, it is not the same as the output file.
I use this command:
ffmpeg -vsync 1 -y -i input.mp4 -i ...
- 111
1
vote
1
answer
685
views
I concatenated two pictures with the "copy /b" commande, and now I want to get the two images back. How can I do this?
So, like the title say, how can I do this? I noticed that the file size has increased, so the two files are really concatenated, and I deleted the original ones, now how can I unmerge the two pictures?...
- 19
0
votes
2
answers
681
views
Using the results of ROW function as cell reference for another function
just wondering if this is possible, I haven't seen an example of it. I have data that I need to match from one excel workbook to another. I have no idea which row the matching data will be in, but I ...
0
votes
1
answer
6k
views
How do I include double quotation mark in a concatenated string in Excel
I have been unable to find a resource that shows how to add double quotation marks to a concatenated excel string. For example if I would like to represent 72 inches as 72" in a string the added ...
- 121
1
vote
1
answer
68
views
How to Concatenate multiple columns at once?
I have an excel sheet as follows:
A B D D E
157 158 14644 28495 Https://www.google.com\
110 111 10142 21123 Https://www.youtube.com\
192 193 18538 36658 Https://www.baidu....
2
votes
1
answer
1k
views
Concat many video: wrong out FPS & audio Pitch
I have a process like this:
i have N input video; I cut & transcode them using the following code:
ffmpeg.exe -c:v h264_cuvid -resize 1920x1080 -noaccurate_seek -ss 00:00:04.000 -to 00:00:44.240 -...
- 31
1
vote
1
answer
2k
views
How do I combine lines of text in Notepad++ that are between string lines into one line of code, while retaining lines outside the string delimiters?
I have 100s of pages in text format in Notepad++ that came from a pdf file. Each page in the file has varying amounts of lines, but they all contain lines that read “TARGET_LINE,” and "...
- 93