Questions tagged [concatenation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Alternative to TEXTJOIN

Currently working on building an Excel form within Microsoft Teams, but it will eventually need to be downloaded to a user computer to be filled out. TEXTJOIN works online within Microsoft Teams, but ...
0
votes
1answer
20 views

Use only video stream for input files in ffmpeg concat demux

I'm using ffmpeg concat demuxer to combine similar files: https://trac.ffmpeg.org/wiki/Concatenate#demuxer My input files have different lengths for video and audio streams. But are otherwise same in ...
0
votes
0answers
21 views

Problems with FTP and segments in FFMPEG

I have the following command... ffmpeg -n -i "ftp://ipaddress/input.mkv" -c:v libx265 -preset medium -crf 20 -f segment -segment_time 60 -reset_timestamps 1 -segment_list "ftp://ipaddress/list....
0
votes
2answers
36 views

#VALUE from IF AND CONCATENATE formula in Excel

Anyone have thoughts on why this won't work? I keep getting #VALUE. =IF(E22:K22<>"", CONCATENATE(E22, " ", "of", " ", G22, " ", "with", " ", K22, " ", "from", " ", I22), "")
0
votes
1answer
45 views

How can i merge hundreds or even thousands of video files into one using ffmpeg or any other tools?

Basically i have like hundreds of small video files (format is .ts) and each of them is like only 10 seconds long and about 10MB size. They are named in order like '100.ts' '101.ts' '102.ts' ... '600....
1
vote
0answers
18 views

Plotting 2 dynamically-sized series on ONE line with Excel

My problem is: with excel, I want to plot 2 series on one line, where the first series has a changing size. Here is an example to better understand it: List_1: can be [0,1,2,3,4,0] or [0,1,2,...,15,...
0
votes
1answer
163 views

FFMPEG Concat result audio delay

I am editing some old homemade videos and I would like to split the files (~2h long, 60 GB) to smaller chunks ~10-15 min long for archiving on different media. Currently I am testing merge/...
2
votes
0answers
19 views

Efficient way to concatenate row titles based on column indicator?

I have a list of ingredients in column A, and different products in columns. The products all consists of different combinations of the same ingredients. In each product's column, there are Y ...
0
votes
1answer
26 views

Convert Multiple Cell Rows Into Single Cells

I am merging two Excel databases and need to ensure that some prices are the same, however, they are stored in two different ways. To facilitate easy comparison of the tables I need to convert a ...
0
votes
1answer
33 views

Require all cells to CONCATENATE

I'm looking to use the concatenate formula to run a multi VLOOKUP. All cells in the CONCATENATE are required to return back the correct information. When cells are blank the CONCATENATE returns only ...
0
votes
1answer
64 views

FFMPEG image concatenation giving different results based on colors in PNG file

I am using the following code to take a number of PNGs of varying durations and the overlaying them over another video. ffmpeg -safe -0 -f concat -i overlap-png.txt -i mainvideo.MOV -...
0
votes
1answer
33 views

how concatenate multiple line with one line

I want to do this but I dont know how : file1: 5000 usernames root ali reza jack . . . output: 5000 emails of usernames root@lpic.org ali@lpic.org reza@lpic.org jack@lpic.org . . .
0
votes
1answer
74 views

How to concat 2 mp4 videos by ffmpeg without having a messing result?

I'm trying to concat 2 mp4 videos with ffmpeg. But the resulted video is not perfect. My files.txt, to point the videos to be concatenated: file 'cutted1.mp4' file 'cutted2.mp4' The ffmpeg command ...
1
vote
0answers
40 views

FFMPEG : Merge 4 files each one including : 1 video + 1 audio + 1 subtitle (eng) + 1 subtitle (esp)

I need to merge TV chapters (24) split into 4 pieces. Each one has : 1 Video stream, 1 Audio stream, 2 Subtitle (SRT) streams. MKVtoolnix is useless here because some are, AVC/Opus another one ...
-2
votes
1answer
25 views

How to I concatenate 2 columns into a unique text

So I have the following Product Customer 1 ABC Ltd 2 EFG Ltd 3 XYZ Ltd I want to create a list that has all combinations, meaning, Product Customer 1 ...
0
votes
1answer
397 views

Concatenating GoPro videos with FFMPEG

I have several GoPro recordings at 60 fps which I would like to concatenate. Is ffmpeg -analyzeduration 2147483647 -probesize 2147483647 -f concat -safe 0 -i concat_list.txt -c copy out.MP4 the right ...
0
votes
1answer
52 views

Excel data dump column formatting

I format a data dump from our software and am trying to streamline the process. The first column contains several groups of characters that are separated with _ between each group. I then take that ...
0
votes
1answer
766 views

concat video and images, and add audio with ffmpeg, but video output skips several images and console returns audio errors

I need to concatenate one video and many images, and add audio. I do not need a particular file format, but I prefer a one-step method without unecessary re-encoding. I tried with the following ...
1
vote
0answers
114 views

forcing ffmpeg to drop audio at same rate it drops video

I've got a number of video files taken over several days on family vacation and I was hoping to combine these all into one 2 hour long file. Some of the source files are from an iPhone, some are from ...
0
votes
1answer
826 views

FFMPEG how to Add timecode Track after Concatenation

ffmpeg -i input1.mp4 -i input2.webm -i input3.mov \ -filter_complex "[0:v:0][0:a:0][1:v:0][1:a:0][2:v:0] \ [2:a:0]concat=n=3:v=1:a=1[outv][outa]" \ -map "[outv]" -map "[outa]" output.mkv How to add ...
2
votes
4answers
3k views

Excel adds quotation marks to the end of my formula

Excel automatically corrects my formula, saying "We found a typo in your formula and tried to correct it to:" =CONCAT(CHAR(34),A4,""":""",D4,"""") My original formula only has three quotation marks ...
0
votes
1answer
273 views

ffmpeg: concat filter does not work

I'm trying to concat multiple (Proof of concept: 2) mp3 files using ffmpeg and the concat filter with the following command: ffmpeg -i "file1.mp3" -i "file2.mp3" -filter_complex [0:a:0][1:a:0]concat=...
0
votes
1answer
76 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
176 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
484 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 ...
0
votes
2answers
73 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
372 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
1k 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
66 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
114 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
1answer
441 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
389 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
161 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
70 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
266 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
27 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
4k 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
3answers
1k 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
77 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 ...
1
vote
2answers
3k 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 ...
3
votes
1answer
4k 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
590 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
99 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
103 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 " - " ...
1
vote
1answer
2k 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
697 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
3k 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
967 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 ...
4
votes
1answer
2k 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
34 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....