Need to prepare a CSV table with inputs from multiple files
Hi,
We have thousands of Video files and we need to prepare a table with few of it's parameters/values from their Mediainfo output. Here I have 3 sample mediainfo output text files named Vid1, Vid2 & Vid3 so on... (such we have thousands) and each file has exactly 3 lines.
Code:
$ ls
Required_para.txt Vid1 Vid2 Vid3
$ wc -l V*
3 Vid1
3 Vid2
3 Vid3
9 total
The file Required_para.txt has list of parameters (and their values) to be extracted into the output file. We might change this file to add/remove parameters.
The output's first line is the list of parameters/values required (comma separated). Each Vid's medianfo will fit in each row with their parameter's values. The 3rd column BitRate is the value of first line's "kb/s" entry of VidX file. 7th column strong-intra-smoothing value should be either 0 (if input has no-strong-intra-smoothing ) OR 1 (if input has strong-intra-smoothing ).
Output file should be like below. I filled-in only few columns.
Hi everyone!!
I have a database table, which has file_name as one of its fields.
Example:
File_ID File_Name Directory Size
0001 UNO_1232 /apps/opt 234
0002 UNO_1234 /apps/opt 788
0003 UNO_1235 /apps/opt 897
0004 UNO_1236 /apps/opt 568
I have to... (3 Replies)
Hi,
I have mutiple csv files at server1 at /apps/test/data.
I needed a script that would copy these csv files from server1 at /usr/data, put them in server2,archive the earlier files that were present in server2 before removing those already present.
Kindly help. (2 Replies)
Hi,
I am regular reader of this forum. My advanced thanks to everyone.
Below given are the sample files
INDATA (Main data)
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
Fild1Çfld2Çfld3…..
.
.
N records (140000) eg
GRPDATA (Reference file) (2 Replies)
Hey gyuz,
I wanna calculate the number of mapped reads of a bam file in a region of interest. I used this code to do so :
samtools view input.bam chrname:region1 > region1.txt
This will store all the reads from given bam file within the region of interest in region1.txt
Now I have... (5 Replies)
Hi,
I'd like to find the values of certain fields in multiple csv files stored in 1 directory
based upon an input search string.
An fgrep returns the complete record, I only want certain fields.
Thanks in advance for your help.
Perry (6 Replies)
Hi guys,
I have a requirement where i need to split a .csv file into multiple files.
Say for example i have data.csv file and i have splitted that into multiple files based on some conditions i.e first file should have 100, last file 50 and other files 1000 each. Am passing the values in... (2 Replies)
Hello,
I have a spec file that contains a lot of strings that looks like this:
PC DELL OptiPlex 3010MT i3 3220/2GB/500GB/DVD-RW/FREE DOS / 5Y NBD
Intel i3 3220 (Dual Core, 3.30GHz, 3MB, w/ HD2500 Graphics), 2GB (1x2GB) DDR3 PC3-1600MHz, 500GB HDD SATA III 7200rpm, DVD+/-RW (16x),... (9 Replies)
Hi,
I need to load data from two files to a single table.
My requirement is that I get two files in which a few column data are manadatory.
These files are identified based on the file name.
For example, I have two files ABCFile and BCDFile. ABCFile has mandatory data in column 3 and 4... (0 Replies)
Hello,
For our work we use several scripts to gather/combine data for use in our webshop. Untill now we did not had any problems but since a couple days we noticed some mismatches between imports.
It happened that several barcodes where matched even though it was a complete other product. Of... (19 Replies)
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
11-02-2019