Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
2 views

FFmpeg - Cut video into segments, transcode them individually, then concatenate & output to .ts

This is a follow-up question to audio error when concatenating clips using ffmpeg What I'd like to achieve is the following: Cut an input video into chunks Transcode each chunk (video and audio) ...
0
votes
0answers
24 views

audio error when concatenating clips using ffmpeg [duplicate]

I'm trying to do the following: cut an input video into segments and convert these segments in the same step concatenate the transcoded segments back together in an output file The steps that I'm ...
0
votes
0answers
39 views

FFMPEG: Generated video will not concat with the rest

I am trying to make a video with FFMPEG, and I am concat'ing several videos together. However, the last two are generated from a PNG image using the -loop option. ffmpeg -loop 1 -i img001.png -filter ...
0
votes
3answers
393 views

VLOOKUP using CONCATENATE values

I have workbook1 with 3 values (columns) concatenated to 1 cell as =TRIM(CONCATENATE("ABC","-",$B174,"-",$A174,"-",$E174)). Workbook2 has 1 cell that contains the concatenated value from workbook1. ...
-1
votes
2answers
97 views

concatenate corresponding values of two cells with comma separated multiple values in it

In excel sheet I have cells with mulitple comma separated values. I want to concatenate the corresponding values of two cells. Example: Cell_A1 (A,B,C,D) and Cell_B1 (E,F,G,H) Then in Cell_C1 it ...
0
votes
1answer
70 views

Multiple Ffmpeg instances choking up the CPU to 100%

I have a task to record timelapse videos from multiple IP-cameras (e.g. camera1.mp4, camera2.mp4, camera#.mp4,etc.). Currently i am running separate ffmpeg.exe instances simultaneously on an MS Azure ...
0
votes
2answers
43 views

Concatenating columns in excel

Need some help in concatenating columns 1 and 2 as seen in screenshot. There will be further entries in column 2, perhaps 'Blue'. I would want '1 Blue' '2 Blue' '3 Blue', etc starting off from ...
0
votes
2answers
161 views

How do I concatenate files using a list and batch?

I need the equivalent of the shell command xargs < list.txt cat -- > compiled.txt as a Windows batch file. There is a directory full of text files (about 50 to 500 files) that I need to ...
0
votes
2answers
320 views

Excel concatenation of one column based on values in another

Similar to this: Excel - pivot values in one cell (as comma-separated value) Except it can be a VBA solution, and I do not have duplicates in Column A. Instead, there are blank rows below each value: ...
8
votes
2answers
255 views

Cannot concatenate videos ffmpeg

I have a bitmap that I would like to concatenate to the front of many videos as a sort of title screen or disclaimer screen. I try to turn it into a video with the same attributes as the rest of the ...
0
votes
1answer
61 views

How can I concatenate multiple clipboard selections in Quicksilver?

I've been using Quicksilver's clipboard module for years but I've always wanted to do this: copy several bits of text. Then paste them as a concat'd list. I found this Stackoverflow post trying to do ...
1
vote
2answers
948 views

Excel - 'Concatenate' columns with Alt + Enter

I am trying to combine three cells into one, with Alt + Enter or Char(10) separating each value. When I use a simple Excel formula =B2 & Char(10) & C2 & Char(10) & D2 and wrap the text ...
0
votes
1answer
71 views

Concatenate a range with values in between

I work with ranged data and want to populate a cell that includes values at set increments between the min and maximum. For example, the minimum outer diameter is 1 1/16" and the maximum outer ...
0
votes
1answer
63 views

Concatenation on 100's columns - Excel

I need to concatenate hundreds of columns, in excel. I've seen I can use CONCATENATE(A1,B1) as explained here but this isn't really practically for concatenating 100 columns. Can this be done ...
0
votes
1answer
597 views

Concatenate binary files in windows (Without command line)

I'm trying to prepare a process for copying the video files off of a recorded DVD (we made the recording, and it's not encrypted). The method of copying the VTS_*.VOB file works when the recording is ...
0
votes
0answers
18 views

Concatenating with line breaks (Batch, Windows 7) [duplicate]

I have a bunch of text files which I already know how to concatenate using copy (batch, windows): copy /a *.txt concat.txt But there are no line breaks between each text field in the resulting file. ...
1
vote
1answer
6k views

How to concatenate a date in MS-excel and receive a date (not a number)

When I try to concatenate two cells in MS-excel in the formula I have the date as a integer number (eg: 04 april 2012 become 41006). How can I display the date also in the formula cells?
0
votes
2answers
1k views

How to concat String, File Contents, and String in bash script?

I have a file which contains only one line $> cat file.txt apple,orange,cat,dog I need to append two String to it and assign it to a variable, one in front and another in the end, so that it ...
0
votes
2answers
191 views

Concatenating a range of values in Excel

I have a set of values that I would like to concat together using a formula. At the moment I am doing it manually using the following formula: =CONCATENATE(A1,":",A2,":") Is there a way to set a ...
2
votes
1answer
146 views

How can I apply cat (UNIX) command individually, to all files in a folder?

Here's the situation: My file A.csv needs to be concatenated individually with all the other *.csv's in the folder and each of the outputs needs to have the same name as the particular *.csv. How ...
0
votes
1answer
607 views

How do I append dynamic number of spaces at the end of a string in a batch file

I want to output information to a log file as such 01/08/2013 14:30 - Dynamic-Machine-Name - Message starts 02/08/2013 07:12 - DynamicMachineName - Log entry 02/08/2013 07:14 - ...
0
votes
1answer
77 views

Excel_prefixed with 0 and how to concatenate those columns in excel

https://www.icts.uiowa.edu/confluence/display/REDCapDocs/Preserving+Prefixed+Zeros+in+Excel with the help of the above link i prefixed the 0 in excel. Now i want to concatenate these columns A &B ...
0
votes
0answers
2k views

VLC to put 2 videos together, output video has glitchy playback and seeking

I am trying to put two videos together (one after the other) using VLC. I did manage to get an output video with both original videos concatenated(That was hard enough to figure out!), but the output ...
1
vote
0answers
92 views

copy /b command size limit issue

I am using copy /b command to append two diff files in one file. This command does not work if the first file is of size larger than 1 GB. I have not found any references or help online. I am using ...
0
votes
1answer
213 views

Concatinating mp4 files to a single mp4 file

I have some mp4 video files with me and i need to concatenate them one by one and make a single MP4 video file. I came to know about FFMPEG through which we can concat files. I tried doing ffmpeg ...
3
votes
1answer
389 views

Windows command to concatenate multiple files in alphabetical/numerical order?

I have several hundred files that need to be concatenated into a single file, much like this question. The problem is, that my files must must be in order. They are named with a Julian date followed ...
4
votes
3answers
4k views

Concatenate multiple WAV files using single command, without extra file

I want to concatenate multiple WAV files into a single WAV file using FFMPEG. I have used the following command and it generates the required file. Command: ffmpeg -f concat -i mylist.txt -c copy ...
3
votes
1answer
551 views

Is there a way in Excel to combine the contents of multiple cells and still leave line breaks?

Consider: +---+----------------------+ | | A | +---+----------------------+ | 1 | Instructions to foo | +---+----------------------+ | 2 | 1.) Foo ...
4
votes
2answers
2k views

Excel - concatenating cells where reference number matches [duplicate]

I have a worksheet with many rows. Some of the rows share reference numbers (contained in, say, column A). What I'd like to do is, where a row shares a reference number with another row, I'd like to ...
2
votes
1answer
948 views

Excel Concatenate Time

I have had a look at this site, and across the net, but can't seem to solve this, which should be easy! Concatenate should work, but I wasn't able to make it work. Current spreadsheet looks like ...
10
votes
5answers
13k 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
4k views

Concatenating numbers that have leading zeros

I'm trying to combine/concatenate numbers in different columns into one long number. Some of the numbers have leading zeros because of custom formats applied to the cells. When I concatenate them ...
2
votes
2answers
372 views

concatenate files including path in header - path contains spaces

I have to concatenate a number of files in a directory structure which contains spaces in the folder names looking like this: ./CH 0000100014/A10/11XT/11xt#001.csv find . -name "*.csv" -type f ...
0
votes
1answer
196 views

#VALUE! error in Microsoft Excel

=IF(ISBLANK(S3);"";CONCATENATE(" UPDATE kkr_urunkredi ku SET ";IF(ISBLANK($A3);"";CONCATENATE(" ku.yatirimsuresi =''";$A3;"''"));" ku.kredikonu_kd =''";$B3;"'', ku.kademeli_drm ...
1
vote
2answers
603 views

gunzip multiple files and concatenate in parallel?

Is it possible to gunzip multiple files and concatenate them into one big file, but do it in parallel given a multicore machine? For example, right now I do: gunzip -c file1.gz > final gunzip -c ...
0
votes
1answer
3k views

Concatenating # with leading 0's in Excel [closed]

I am trying to concatenate 3 fields together but some of the fields have leading 0's. Does anyone know of a way to use this formula and still be successful?
12
votes
1answer
2k views

Linux command to concatenate a file to itself n times

I've taken a plain text file book from Project Gutenberg (around 0.5MB) which I want to concatenate to itself n times in order to generate a large text file that I can benchmark some algorithms on. ...
1
vote
2answers
7k views

how to combine or concatenate two video files with ffmpeg?

I have tried to concatenate 2 video files (avi) into one sigle video: cat input1.avi input2.avi | ffmpeg -f avi -i - -vcodec copy -acodec copy final.avi .. but this does not concatenate the videos. ...
0
votes
2answers
2k views

How can I include quotations in a CONCATENATE operation?

I've got an Excel file with a list of file paths that I need to perform actions on, via batch operation. I figured the best way to do this would be to write a CONCATENATE formula to put together the ...
3
votes
2answers
691 views

concatenate cmd line starting from some parameter

If I get a cmd line like: myscript param1 param2 param3 param4 param5 param6 ... (so on) How can I save a string consisting of parameters starting from some specific one? The $@ gives me the whole ...
1
vote
1answer
2k views

How to concatenate audio files in Adobe Audition 3?

I have about 200 AC3 files that I want to import into Adobe Audition 3 using AC3Filter plug-in. If I select all files and drag to session area, I get one per track, instead I want them all ...
6
votes
5answers
5k views

Join Audio and Image -> Output as Video using FFmpeg

I have 1 image (jpg) and 1 audio file (MP3) and I would like to output this as a video file (say AVI for example). Does anyone know how to use FFMPEG to join the two? I'd like to show the image for ...
5
votes
1answer
794 views

Successfully concatenating multiple videos

My mission is to create videos out of old web slideshows. To start with I have jpegs and audio files that worked as Flash slideshows in an old system, structured such as this: Audio structure ...
1
vote
1answer
797 views

Concatenate cells that change daily automatically?

I use concatenate to pull data together from different cells in my spreadsheet. Since my data changes daily, I want the formula to also change daily without having to manually input the new cell in ...
5
votes
5answers
73k views

How to merge/combine files with extensions .001, .002, .003.. etc? [duplicate]

Possible Duplicate: Good free software that will join .001 files? There are files on sites like rapidshare which have extensions like .001, .002, .003? They seem to be split by some tool. ...
8
votes
5answers
14k views

How can I join multiple .mpg movie files?

I create a lot of these small clips on my digital camera. These are in .mpg format and before I share them with others, I would love to just join, clip a few seconds here and there. I use Google ...
6
votes
2answers
1k views

Concatenate files over FTP

I have a list of files on an FTP server that I would like to concatenate remotely. They are quite large, so I would prefer not to download them. The reason I'm in this situation is because I ...