The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
22 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
17 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
16 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
35 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
28 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 ...
0
votes
0answers
70 views

(FFmpeg) Concatenation with text files error, “TEXT.txt:Invalid argument”

In Concat.txt, I listed out the files to concatenate by: file 'Vid_1.mp4' file 'Vid_2.mp4' In my code, I simply use: ffmpeg -f concat -i Concat.txt -c copy OUTPUT_VID.mp4 Concat.txt and the ...
1
vote
1answer
42 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: ...
1
vote
1answer
72 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
27 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
1answer
69 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 ...
0
votes
0answers
18 views

Query Concatenation

I need to concatenate 5 fields together. Now the problem is field field2 could have data but not field1 which gives me a headache of extra white space at the beginning and an un-necessary comma if I ...
1
vote
2answers
31 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: ...
0
votes
0answers
33 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
226 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 ...
0
votes
1answer
125 views

how to concatenate files within each subdirectory using windows command prompt

I'm a newbie, a grad student, and frustrated!! I have tons of directories containing subdirectories and each subdirectory contains a bunch of .irf files (these are a DVR-type file). I am trying to ...
2
votes
1answer
381 views

Concatenate videos with/without audio stream

I have multiple videos in folder, but when first of all hasn't audio stream, audio disappear in concatenated video. Concatenated video is correct if first video has audio stream. How can I concatenate ...
0
votes
2answers
244 views

ffmpeg for Mac “no such file or directory” (when file exists)

I'm using OSX 10.10.1 and I'm trying to concatenate .mp4 files with the ffmpeg demuxer. Below is what I enter and the error I get. Please help! I'm not a programmer but I had the demuxer working on my ...
0
votes
0answers
133 views

Excel: Conditional formatting for column merge

I'm looking to create a timetable that is formed by combining material from several worksheets. It does not seem to be possible to automatically consolidate text from several worksheets, but it is, of ...
0
votes
2answers
711 views

Batch - How to cat multiple files together without header records

I'm attempting to merge multiple files together with the following command: copy test1.txt+test2.txt test3.txt This works just fine, however, the files I'm attempting to merge contain header records ...
3
votes
2answers
472 views

Command Line : Concatenate multiple files by date

I have got a plenty of .txt files in a directory. The directory also contains .png and some .pdf files. I have successfully concatenated .txt files using this command : @ECHO Off SETLOCAL for /r %%f ...
0
votes
0answers
459 views

FFMPEG concat demuxer — how to make mp4 file formats compatible

I need to automate mp4 concatenation server-side and I'm using FFMPEG. I will get uploads of mp4 files and I want to attach a Title.mp4 and End.mp4 to each one. I am also overlaying a soundtrack (the ...
1
vote
2answers
62 views

Concatenation in JS functions [closed]

First question here. I am doing Codecademy's JS basics course and have run into a question concerning concatenation in functions. I have: var greeting = function(name){ console.log("Hello, "+"" ...
0
votes
1answer
1k views

How to lookup a value and return multiple unique values (remove duplicates) to a single cell - comma separated

I am trying to take a value (unique id) from column AC, do a lookup in column (B) and return (meaning concatenate) the multiple unique values from an adjacent column (C) to a single cell in column AD. ...
0
votes
1answer
252 views

ffmpeg filter_complex concat does not include audio

I've managed to put together an ffmpeg filter complex which: Scales an FBI warning (fbi.mp4) to the size ($w:$h) of a training video (train.mp4). Pads the FBI warning so it's centered. Concats the ...
2
votes
2answers
366 views

How to concatenate values in Excel?

I have a spreadsheet that looks something like this:    A B C D E ... 1| 1 0 0 1 0 2| 0 1 0 0 1 3| 0 0 0 1 0 4| 1 0 0 0 0 I'd like to concatenate row 1 in column F so ...
1
vote
1answer
287 views

Excel: combine strings based on duplicate keys

I have two columns Key and Value (standard map) There are duplicated keys. It is trivial to delete the duplicated keys (namely the delete duplicates button). But that would delete some useful data in ...
1
vote
1answer
138 views

How to CONCATENATE a VLOOKUP and have the lookup take place without an CR after a copy and paste value

A B C =VLOOKUP(C1,B6:C8,2) =VLOOKUP(C1,B6:C8,2) =VLOOKUP(C1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(A1,B6:C8,2) ...
1
vote
1answer
141 views

How to Concatenate Repeating String in Batch Script

I'm trying to concatenate a repeating string depending on the first parameter value passed into the script when it is called. This value represents the number of directory levels the current ...
1
vote
1answer
98 views

FFMPEG blank tiny audio spot when concating

Ok, im trying to concat some mp3 audio files with the following command: ffmpeg -y -i concat:"1.mp3|2.mp3|3.mp3" -c copy output.mp3 After concating output.mp3 isn't perfect, it leaves some tiny ...
2
votes
1answer
630 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
29 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
1answer
103 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
6k views

VLOOKUP using CONCATENATE values [closed]

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
298 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
300 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
78 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
559 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
1k 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: ...
9
votes
2answers
450 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
123 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
5k 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
2answers
136 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
328 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 ...
1
vote
1answer
2k 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 ...
9
votes
1answer
62k 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
4k 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
349 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
175 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 ...
1
vote
1answer
2k 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
121 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 ...