|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to split a data file into separate files with the file names depending upon a column's value?
Post 302558757 by itkamaraj on Sunday 25th of September 2011 07:38:24 AM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file which contains records of data.
I need to split the file into multiple files depending upon the value of last field.
How do i read the last field of each record in the file???
Regards,
Chaitrali (4 Replies)
Discussion started by: Chaitrali
4 Replies
2. Shell Programming and Scripting
Hi All,
I have a file like below:
1016D"ddd","343","1299"
1016D"ddd","3564","1299"
1016D"ddd","3297","1393"
1016D"ddd","32989","1527"
1016D"ddd","346498","1652"
2312D"ddd","3269","1652"
2312D"ddd","328","1652"
2312D"ddd","2224","2100"
3444D"ddd","252","2100"
3444D"ddd","2619","2100"... (4 Replies)
Discussion started by: deepakgang
4 Replies
3. Shell Programming and Scripting
I have a 500 MB XML file from a FileMaker database export, it's formatted horribly (no line breaks at all). The node structure is basically
<FMPXMLRESULT>
<METADATA>
<FIELD att="............." id="..."/>
</METADATA>
<RESULTSET FOUND="1763457">
<ROW att="....." etc="....">
... (16 Replies)
Discussion started by: JRy
16 Replies
4. UNIX for Dummies Questions & Answers
I have a text file with 1,000,000 rows (It is a single column text file of numbers). I would like to separate the text file into 100 files of equal size (i.e. number of rows). The first file will contain the first 10,000 rows, the second row will contain the second 10,000 rows (rows 10,001-20,000)... (2 Replies)
Discussion started by: evelibertine
2 Replies
5. Shell Programming and Scripting
Hi,
As a newbie, I'm desperate ro make my shell script work. I'd like a script which checks all the files in a directory, check the file name, if the file name ends with "extracted", store it in a variable, if it has a suffix of ".roi" stores in another variable. I'm going to use these two... (3 Replies)
Discussion started by: armando110
3 Replies
6. Shell Programming and Scripting
hello!
i need a little help from you :) ... i need to split a file into separate files depending on two conditions using scripting. The file has no delimiters. The conditions are col 17 = "P" and col 81 = "*", this will go to one output file; col 17 = "R" and col 81 = " ". Here is an example.
... (3 Replies)
Discussion started by: chanclitas
3 Replies
7. Shell Programming and Scripting
Hi ,
cat myfile.txt
! 3100.2.0.5 ! 3100.2.22.4 ! 3100.2.30.33 ! 3100.2.4.1 !
! 3100.2.0.5 ! 3100.2.22.4 ! 3100.2.22.11 ! 3100.2.4.1 !
! 3100.2.0.5 ! 3100.2.2.50 ! 3100.2.22.11 ! 3100.2.4.1 !
! 3100.2.0.5 ! 3100.2.22.4 ! 3100.2.30.33 ! 3100.2.4.1 !
! 3100.2.0.5 ! 3100.2.22.4 !... (6 Replies)
Discussion started by: OTNA
6 Replies
8. Shell Programming and Scripting
Hi ,
my file look likes below ,
cat file.csv
12/09/2014,50,5,0,300
12/09/2014, ,5,0,300
12/09/2014,50,,,300
i need to split file , the first one contains values (2nd column is 50 , 3rd and fourth column is null )
the second file contains all others
firstfile
... (2 Replies)
Discussion started by: ubaisalih
2 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have one large files of 100000 rows with header column.
Eg:
Emp Code, Emp Name
101,xxx
102,YYY
103,zzz
...
...
I want to split the files into smaller files with only 30000 rows each..File 1,2 and 3 must have 30000 rows and file 4 must contain 10000 rows.
But the column... (1 Reply)
Discussion started by: Nivas
1 Replies
10. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: Sharma331
1 Replies
LEARN ABOUT PHP
db2_field_type
DB2_FIELD_TYPE(3) 1 DB2_FIELD_TYPE(3) db2_field_type - Returns the data type of the indicated column in a result set SYNOPSIS
string db2_field_type (resource $stmt, mixed $column) DESCRIPTION
Returns the data type of the indicated column in a result set. PARAMETERS
o $stmt - Specifies a statement resource containing a result set. o $column - Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column. RETURN VALUES
Returns a string containing the defined data type of the specified column. If the specified column does not exist in the result set, db2_field_type(3) returns FALSE. SEE ALSO
db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3). PHP Documentation Group DB2_FIELD_TYPE(3)