Questions tagged [concatenation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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&...
Scott's user avatar
  • 1
0 votes
0 answers
464 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....
Rens's user avatar
  • 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 ...
Robert MATTHEWS 馬學進's user avatar
0 votes
0 answers
63 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 ...
Binarus's user avatar
  • 1,805
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 ...
Vignesh K's user avatar
0 votes
0 answers
75 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: ...
user1850133's user avatar
1 vote
0 answers
113 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. ...
ZioByte's user avatar
  • 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 ...
Ram Sambamurthy's user avatar
0 votes
1 answer
197 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 ...
user3083171's user avatar
-1 votes
1 answer
412 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 '...
imkira3's user avatar
  • 19
0 votes
0 answers
181 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 ...
Shreyas's user avatar
0 votes
0 answers
241 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 ...
Matteo Pasini's user avatar
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. ...
Bardan Pokhrel's user avatar
1 vote
1 answer
221 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 ...
Aakash Chakravarthy's user avatar
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 ...
Aakash Chakravarthy's user avatar
0 votes
0 answers
142 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 ...
Lucas McKamey's user avatar
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, ...
user1786072's user avatar
0 votes
1 answer
678 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], ...
ttb's user avatar
  • 1
0 votes
1 answer
141 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 ...
Eric Fail's user avatar
  • 263
0 votes
0 answers
50 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 ...
Eric Fail's user avatar
  • 263
1 vote
1 answer
119 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 ...
Dave Hill's user avatar
0 votes
2 answers
168 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 ...
James's user avatar
  • 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 ...
3EK's user avatar
  • 1
0 votes
2 answers
188 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 ...
Eoin's user avatar
  • 963
0 votes
2 answers
125 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 ...
Marjorie Bask's user avatar
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 ...
raoulpetite's user avatar
2 votes
1 answer
792 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 ...
Franck Dernoncourt's user avatar
0 votes
2 answers
764 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 ...
Rick Kirkman's user avatar
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 ...
nemu's user avatar
  • 3
0 votes
1 answer
561 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 ...
BigBear5000's user avatar
0 votes
1 answer
291 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 | ...
jefferis's user avatar
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 ...
SacDeb's user avatar
  • 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 ...
Gramrock's user avatar
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 ...
Memes's user avatar
  • 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 ...
Akshay Iyer's user avatar
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 ...
DataMsc's user avatar
  • 11
0 votes
1 answer
379 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" ...
Always an Artist's user avatar
1 vote
0 answers
153 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 ...
Kent Loomis's user avatar
0 votes
1 answer
325 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 ...
D.B.'s user avatar
  • 101
0 votes
1 answer
649 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 ...
D.B.'s user avatar
  • 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:\...
D.B.'s user avatar
  • 101
1 vote
1 answer
563 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....
D.B.'s user avatar
  • 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 ...
D.B.'s user avatar
  • 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 ...
user3884677's user avatar
1 vote
1 answer
693 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?...
Rachid's user avatar
  • 19
0 votes
2 answers
686 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 ...
ExcelUser2021's user avatar
0 votes
1 answer
7k 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 ...
A.K.'s user avatar
  • 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....
usernullusernull's user avatar
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 -...
Marco Soave's user avatar
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 "...
mapman's user avatar
  • 93