Divide data with specific column values into separate files Post: 302629441

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Divide large data files into smaller files

Hello everyone! I have 2 types of files in the following format: 1) *.fa >1234 ...some text... >2345 ...some text... >3456 ...some text... . . . . 2) *.info >1234

2. Shell Programming and Scripting

How to split a data file into separate files with the file names depending upon a column's value?

Hi, I have a data file xyz.dat similar to the one given below, 2345|98|809||x|969|0 2345|98|809||y|0|537 2345|97|809||x|544|0 2345|97|809||y|0|651 9685|98|809||x|321|0 9685|98|809||y|0|357 9685|98|709||x|687|0 9685|98|709||y|0|234 2315|98|809||x|564|0 2315|98|809||y|0|537...

3. Shell Programming and Scripting

Divide data into separate files

frnds: i want to divide data on the behalf of dotted line and redirectd into new files ) ------------------------- M-GET CONFIRMATION ( ------------------------- M-GET CONFIRMATION ( INVOKE IDENTIFIER final data shuld be into 3 files ......

4. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........

5. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please...

6. Shell Programming and Scripting

Print every 5 4th column values as separate row with different first column

Hi, I have the following file, chr1 100 200 20 chr1 201 300 22 chr1 220 345 23 chr1 230 456 33.5 chr1 243 567 90 chr1 345 600 20 chr1 430 619 21.78 chr1 870 910 112.3 chr1 914 920 12 chr1 930 999 13 My output would be peak1 20 22 23 33.5 90 peak2 20 21.78 112.3 12 13 Here the...

7. UNIX for Dummies Questions & Answers

Divide a numerical data column by a variable

Hello, I have two files, f1 and f2. f1 has 5 columns like so: a b c d 154 e f g h 365 ..... f2 has two columns, the first column contains the name of the above file and second column contains a constant which is to be used for division. e.g. file1 56 I want to divide the 5th...

8. Shell Programming and Scripting

Sum values of specific column in multiple files, considering ranges defined in another file

I have a file (let say file B) like this: File B: A1 3 5 A1 7 9 A2 2 5 A3 1 3 The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines...

9. Shell Programming and Scripting

How to separate rows of data into another column?

I have data such as below where the value in second field is the same as that in the row after. 123456,22222,John,0,xyz 234567,22222,John1,1,cde 43212,3333,Jean,3,pip 84324,3333,Abel,2,cat I'd like to rearrange the output like below to put such records beside each other and separated with...

10. Shell Programming and Scripting

How to separate data coming in one column of CSV file?

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file. The issue is that all the data comes in to the same column, i want them to be separated in different columns. SQL_COMMAND=command.sql file=file.txt formatFile=formatFile.txt report=report.csv echo...

LEARN ABOUT DEBIAN

tv_split

TV_SPLIT(1p)						User Contributed Perl Documentation					      TV_SPLIT(1p)

NAME

       tv_split - Split XMLTV listings into separate files by date and channel.

SYNOPSIS

       tv_split --output TEMPLATE [FILE...]

DESCRIPTION

       Read XMLTV listings and split them into some number of output files.  The output file chosen for each programme is given by substitutions
       on the filename template supplied.  You can split listings by time and by channel.

       The TEMPLATE is a filename but substitutions are applied: first %channel is replaced with the id of a programme's channel, and then
       Date::Manip substitutions (which broadly follow date(1)) are applied based on the start time of each programme.	In this way each programme
       is written to a particular output file.	When an output file is created it will also contain all the channel elements from the input.

       One or more input files can be given; if more than one then they are concatenated in the same way as tv_cat.  If no input files are given
       then standard input is read.

EXAMPLE

       Use "tv_split --output %channel-%Y%m%d.xml" to separate standard input into separate files for each day and channel.  The files will be
       created with names like bbc1.bbc.co.uk-20020330.xml.

SEE ALSO

       Date::Manip(3).

AUTHOR

       Ed Avis, ed@membled.com.

perl v5.14.2							    2004-01-20							      TV_SPLIT(1p)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Divide large data files into smaller files

Discussion started by: ad23

2. Shell Programming and Scripting

How to split a data file into separate files with the file names depending upon a column's value?

Discussion started by: nithins007

3. Shell Programming and Scripting

Divide data into separate files

Discussion started by: dodasajan

4. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Discussion started by: prashali