Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Split file when the key field change !
Top Forums Shell Programming and Scripting Split file when the key field change ! Post 302558514 by csierra on Friday 23rd of September 2011 07:54:11 PM
Old 09-23-2011
Question Split file when the key field change !
Hello,

I have the following example data file:

Code:
Rv.Global_Sk,1077.160523,D,16/09/2011
Rv.Global_Sk,1077.08098,D,17/09/2011
Rv.Global_Sk,1077.001445,D,18/09/2011
Rv.Global_Sk,1072.660733,D,19/09/2011
Rv.Global_Sk,1070.381557,D,20/09/2011
Rv.Global_Sk,1071.971747,D,21/09/2011
Rv.Global_Sk,1056.547923,D,22/09/2011
Rf.Col_Estabil,568.4547,D,04/01/2000
Rf.Col_Estabil,568.7978,D,05/01/2000
Rf.Col_Estabil,569.0438,D,06/01/2000
Rf.Col_Estabil,569.1829,D,07/01/2000
Rf.Col_Estabil,570.0619,D,11/01/2000
Rf.Col_Estabil,570.2699,D,12/01/2000
Rf.Col_Estabil,570.3019,D,13/01/2000
Rf.Col_Estabil,570.5283,D,14/01/2000

Could you please help me with an awk shell script for split in files when change the first key field to the name of the field plus the .csv extension, for instance Rf.Col_Estabil.csv.

Thanks in advance
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Please Help:Need to Split the file into mutliple files depends on the KEY field value

Hi Gurus, I am new to UNIX(HP). my requirmnet is File needs to needs to be split into multiple files dependa on one key value. example 1 abc 333 us 2 bbc 444 ch 5 nnn 333 kk 7 hhh 555 ll 3 hhh 333 hh now the requirment is line with 333 should be copied into test1.txt and... (14 Replies)
Discussion started by: arund_01
14 Replies

2. Shell Programming and Scripting

Split file based on field

Hi I have a large file 2.6 million records and I am trying to split the file based on last column. I am doing awk -F"|" '{ print > $NF }' filename1 After around 1000 splits it gives me a error awk: can't open file 3332332423 input record number 1068, file filename1 source... (6 Replies)
Discussion started by: s_adu
6 Replies

3. Shell Programming and Scripting

split large file based on field criteria

I have a file containing date/time sorted data of the form ... 2009/06/10,20:59:59.950,XAG/USD,Q,1,1115, 14.3025,100,1,1 2009/06/10,20:59:59.950,XAG/USD,Q,1,1116, 14.3026,125,1,1 2009/06/10,20:59:59.950,XAG/USD,R,0,0, , 0,0,0 2009/06/10,20:59:59.950,XAG/USD,R,1,0, 14.1910,100,1,1... (6 Replies)
Discussion started by: asriva
6 Replies

4. Shell Programming and Scripting

awk or sed? change field conditional on key match

Hi. I'd appreciate if I can get some direction in this issue to get me going. Datafile1: -About 4000 records, I have to update field#4 in selected records based on a match in the key field (Field#1). -Field #1 is the key field (servername) . # of Fields may vary # comment server1 bbb ccc... (2 Replies)
Discussion started by: RascalHoudi
2 Replies

5. Shell Programming and Scripting

awk to split one field and print the last two fields within the split part.

Hello; I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Discussion started by: yifangt
5 Replies

6. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

7. UNIX for Dummies Questions & Answers

Split a file into parts only if the first field is different

Hi, I have a file like this: aaa 123 aaa 223 aaa 225 bbb 332 bbb 423 bbb 6755 bbb 324 ccc 112 ccc 234 ccc 897 Which I need to split into several files, something like split -l 3 but the way that the lines with the same names would only go into one file: (7 Replies)
Discussion started by: coppuca
7 Replies

8. Shell Programming and Scripting

Split file based on a column/field value

Hi All, I have a requirement to split file into 2 sets of file. Below is a sample data of the file AU;PTN;24EX;25-AUG-14;AU;123;SE;123;Test NN;;;;ASD; AU;PTN;24EX;25-AUG-14;AU;456;SE;456;Test NN;;;;ASD; AU;PTN;24EX;25-AUG-14;AU;147;SE;147;Test NN;;;;ASD;... (6 Replies)
Discussion started by: galaxy_rocky
6 Replies

9. Shell Programming and Scripting

EBCDIC File Split Based On Record Key

I was wondering if anyone could explain to me how to split a variable length EBCDIC file into seperate files based on the record key. I have the COBOL layout, and so I need to split the file into 13 different EBCDIC files so that I can run each one through a C++ converter I have, and get the... (11 Replies)
Discussion started by: hanshot1stx
11 Replies

10. Shell Programming and Scripting

Update a specific field in file with Variable value based on other Key Word

I have an input file with A=xyz B=pqr I would want the value in Second Field (xyz or pqr) updated with a value present in Shell Variable based on the value passed in the first field. (A or B ) while read line do NEW_VALUE = `some functionality done on $line` If $line=First Field-... (1 Reply)
Discussion started by: infernalhell
1 Replies

LEARN ABOUT FREEBSD

gb18030

GB18030(5)						      BSD File Formats Manual							GB18030(5)

NAME

     gb18030 -- GB 18030 encoding method for Chinese text

SYNOPSIS

     ENCODING "GB18030"

DESCRIPTION

     The GB18030 encoding implements GB 18030-2000, a PRC national standard for the encoding of Chinese characters.  It is a superset of the older
     GB 2312-1980 and GBK encodings, and incorporates Unicode's Unihan Extension A completely.	It also provides code space for all Unicode 3.0
     code points.

     Multibyte characters in the GB18030 encoding can be one byte, two bytes, or four bytes long.  There are a total of over 1.5 million code
     positions.

     GB 11383-1981 (ASCII) characters are represented by single bytes in the range 0x00 to 0x7F.

     Chinese characters are represented as either two bytes or four bytes.  Characters that are represented by two bytes begin with a byte in the
     range 0x81-0xFE and end with a byte either in the range 0x40-0x7E or 0x80-0xFE.

     Characters that are represented by four bytes begin with a byte in the range 0x81-0xFE, have a second byte in the range 0x30-0x39, a third
     byte in the range 0x81-0xFE and a fourth byte in the range 0x30-0x39.

SEE ALSO

     euc(5), gb2312(5), gbk(5), utf8(5)

     Chinese National Standard GB 18030-2000: Information Technology -- Chinese ideograms coded character set for information interchange --
     Extension for the basic set, March 2000.

     The Unicode Standard, Version 3.0, The Unicode Consortium, 2000.

STANDARDS

     The GB18030 encoding is believed to be compatible with GB 18030-2000.

BSD
								  August 10, 2003							       BSD
All times are GMT -4. The time now is 02:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy