Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with split a list of records into each line with 200 coordinate at a time
Top Forums Shell Programming and Scripting Help with split a list of records into each line with 200 coordinate at a time Post 303022197 by perl_beginner on Monday 27th of August 2018 10:24:58 AM
Old 08-27-2018
Help with split a list of records into each line with 200 coordinate at a time
Input File:
Code:
E	3359799	3360148	350	X
D	3471287	3471607	321	X
E	3359799	3360740	942	X
E	4359790	4360039	250	X
.
.
.

Desired Output File:
Code:
E	3359799	3359998	200	X
E	3359999	3360148	150	X
D	3471287	3471486	200	X
D	3471487	3471607	121	X
E	3359799	3359998	200	X
E	3359999	3360198	200	X
E	3360199	3360398	200	X
E	3360399	3360598	200	X
E	3360599	3360740	142	X
E	4359790	4359989	200	X
E	4359990	4360039	50	X
.
.
.

My input file have 5 columns data.
Column 1 is Sample ID;
Column 2 is Start;
Column 3 is End;
Column 4 is Distance (End-Start+1);
Column 5 is Target;

Anyone know how to using awk, perl or any programming language that can split a list of record in Input File with 200 coordinate at a time?
Every line at Input File is represents a record. I hope to split it with 200 coordinate at a time.

Thanks for any advice.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List UID's between 100 and 200

If i wanted to list all users who have a UID between 100 and 200 which command would i use? (1 Reply)
Discussion started by: warlock129
1 Replies

2. UNIX for Dummies Questions & Answers

Split 200.000 files into different subfolders

Dear UNIX-Community, can help me doing 2 things in Debian 5.0? 1.) Create 100 folders Format: ./0/0, ./0/1, ./0/2, ...,./0/9, ./1/0/, ..., ./9/9 2.) Move over 200.000 files into the subdirectories according to their last digits. 12398123.dat -> ./3/2/12398123.dat 48161.dat ->... (2 Replies)
Discussion started by: diadas
2 Replies

3. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

4. Shell Programming and Scripting

Split a single record to multiple records & add folder name to each line

Hi Gurus, I need to cut single record in the file(asdf) to multile records based on the number of bytes..(44 characters). So every record will have 44 characters. All the records should be in the same file..to each of these lines I need to add the folder(<date>) name. I have a dir. in which... (20 Replies)
Discussion started by: ram2581
20 Replies

5. Shell Programming and Scripting

split records into different files

Hi All, I want my file to be split based on value of 'N' (passed as argument). If value of 'N' is '2' then 4 new files will be generated from the below source file and the o/p file shoud look like File_$num , where num will be incremental. Source file: 1 2 3 4 5 O/p Files: ... (6 Replies)
Discussion started by: HemaV
6 Replies

6. Shell Programming and Scripting

Split records into multiple records

Hi All, I am trying to split a record into multiple records based on a value. Input.txt "A",1,0,10 "B",2,0,10,15,20 "C",3,11,14,16,19,21,23 "D",1,0,5 My desired output is: "A",1,0,10 "B",2,0,10 "B",2,15,20 "C",3,11,14 "C",3,16,19 "C",3,21,23 (4 Replies)
Discussion started by: kmsekhar
4 Replies

7. Shell Programming and Scripting

Split Records

I have a flat file with 2 columns Id,loc 1,nj:ny:pa 2,pa 3,ca:tx:fl:nj Second colum data is seperated by semi colon and can i have many locations for one id Output i need is 1,nj 1,ny 1,pa 1,pa 3,ca 3,tx 3,fl (1 Reply)
Discussion started by: traininfa
1 Replies

8. Shell Programming and Scripting

Sorting with list, - 2 lists next to 200

Hi I was wondering if anyone knew the best way to have files displayed by list so that they were in numerical order? the problem I am having is I am using the ls and the head command to sort a group of 500 files into manageable 133 file bunches and transfer them to another directory were they will... (4 Replies)
Discussion started by: Paul Walker
4 Replies

9. Shell Programming and Scripting

Split records

Hi I have a file $cat test a,1;2;3 b,4;5;6;7 c,8;9 I want to split each record to multiple based on semicolon in 2nd field. i.e a,1 a,2 a,3 b,4 b,5 (3 Replies)
Discussion started by: Shivdatta
3 Replies

LEARN ABOUT OPENSOLARIS

iconv_1251

iconv_1251(5)						Standards, Environments, and Macros					     iconv_1251(5)

NAME

       iconv_1251 - code set conversion tables for MS 1251 (Windows Cyrillic)

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |		     Code Set Conversions Supported			 |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output	 |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |KOI8-R	      |koi8    | KOI8-R 		 |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |Mac Cyrillic  |mac     | Macintosh Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   MS 1251 to ISO 8859-5
       For the conversion of MS 1251 to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     |  ISO 8859-5	|   MS 1251	 |  ISO 8859-5	 |
       |24	       | 4		|310		 |270		 |
       |200	       | 242		|311		 |271		 |
       |201	       | 243		|312		 |272		 |
       |202	       | 40		|313		 |273		 |
       |203	       | 363		|314		 |274		 |
       |204-207        | 40		|315		 |275		 |
       |210	       | 255		|316		 |276		 |
       |211	       | 40		|317		 |277		 |
       |212	       | 251		|320		 |300		 |
       |213	       | 40		|321		 |301		 |
       |214	       | 252		|322		 |302		 |
       |215	       | 254		|323		 |303		 |
       |216	       | 253		|324		 |304		 |
       |217	       | 257		|325		 |305		 |
       |220	       | 362		|326		 |306		 |
       |221-227        | 40		|327		 |307		 |
       |230	       | 255		|330		 |310		 |
       |231	       | 40		|331		 |311		 |
       |232	       | 371		|332		 |312		 |
       |233	       | 40		|333		 |313		 |
       |234	       | 372		|334		 |314		 |
       |235	       | 374		|335		 |315		 |
       |236	       | 373		|336		 |316		 |
       |237	       | 377		|337		 |317		 |
       |241	       | 256		|340		 |320		 |
       |242	       | 376		|341		 |321		 |
       |243	       | 250		|342		 |322		 |
       |244-247        | 40		|343		 |323		 |
       |250	       | 241		|344		 |324		 |
       |251	       | 40		|345		 |325		 |
       |252	       | 244		|346		 |326		 |
       |253-254        | 40		|347		 |327		 |
       |255	       | 55		|350		 |330		 |
       |256	       | 40		|351		 |331		 |
       |257	       | 247		|352		 |332		 |
       |260-261        | 40		|353		 |333		 |
       |262	       | 246		|354		 |334		 |
       |263	       | 366		|355		 |335		 |
       |264-267        | 40		|356		 |336		 |
       |270	       | 361		|357		 |337		 |
       |271	       | 360		|360		 |340		 |
       |272	       | 364		|361		 |341		 |
       |273	       | 40		|362		 |342		 |
       |274	       | 370		|363		 |343		 |
       |275	       | 245		|364		 |344		 |
       |276	       | 365		|365		 |345		 |
       |277	       | 367		|366		 |346		 |
       |300	       | 260		|367		 |347		 |
       |301	       | 261		|370		 |350		 |
       |302	       | 262		|371		 |351		 |
       |303	       | 263		|372		 |352		 |
       |304	       | 264		|373		 |353		 |
       |305	       | 265		|374		 |354		 |
       |306	       | 266		|375		 |355		 |
       |307	       | 267		|376		 |356		 |
       +---------------+----------------+----------------+---------------+

   MS 1251 to KOI8-R
       For the conversion of MS 1251 to KOI8-R , all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     |    KOI8-R	|   MS 1251	 |   KOI8-R	 |
       |24	       | 4		|310		 |351		 |
       |200	       | 261		|311		 |352		 |
       |201	       | 262		|312		 |353		 |
       |202	       | 40		|313		 |354		 |
       |203	       | 242		|314		 |355		 |
       |204-207        | 40		|315		 |356		 |
       |210	       | 255		|316		 |357		 |
       |211	       | 40		|317		 |360		 |
       |212	       | 271		|320		 |362		 |
       |213	       | 40		|321		 |363		 |
       |214	       | 272		|322		 |364		 |
       |215	       | 274		|323		 |365		 |
       |216	       | 273		|324		 |346		 |
       |217	       | 277		|325		 |350		 |
       |220	       | 241		|326		 |343		 |
       |221-227        | 40		|327		 |376		 |
       |230	       | 255		|330		 |373		 |
       |231	       | 40		|331		 |375		 |
       |232	       | 251		|332		 |377		 |
       |233	       | 40		|333		 |371		 |
       |234	       | 252		|334		 |370		 |
       |235	       | 254		|335		 |374		 |
       |236	       | 253		|336		 |340		 |
       |237	       | 257		|337		 |361		 |
       |241	       | 276		|340		 |301		 |
       |242	       | 256		|341		 |302		 |
       |243	       | 270		|342		 |327		 |
       |244-247        | 40		|343		 |307		 |
       |250	       | 263		|344		 |304		 |
       |251	       | 40		|345		 |305		 |
       |252	       | 264		|346		 |326		 |
       |253-254        | 40		|347		 |332		 |
       |255	       | 55		|350		 |311		 |
       |256	       | 40		|351		 |312		 |
       |257	       | 267		|352		 |313		 |
       |260-261        | 40		|353		 |314		 |
       |262	       | 266		|354		 |315		 |
       |263	       | 246		|355		 |316		 |
       |264-267        | 40		|356		 |317		 |
       |270	       | 243		|357		 |320		 |
       |271	       | 260		|360		 |322		 |
       |272	       | 244		|361		 |323		 |
       |273	       | 40		|362		 |324		 |
       |274	       | 250		|363		 |325		 |
       |275	       | 265		|364		 |306		 |
       |276	       | 245		|365		 |310		 |
       |277	       | 247		|366		 |303		 |
       |300	       | 341		|367		 |336		 |
       |301	       | 342		|370		 |333		 |
       |302	       | 367		|371		 |335		 |
       |303	       | 347		|372		 |337		 |
       |304	       | 344		|373		 |331		 |
       |305	       | 345		|374		 |330		 |
       |306	       | 366		|375		 |334		 |
       |307	       | 372		|376		 |300		 |
       +---------------+----------------+----------------+---------------+

   MS 1251 to PC Cyrillic
       For the conversion of MS 1251 to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     |  PC Cyrillic	|   MS 1251	 | PC Cyrillic	 |
       |24	       | 4		|332		 |232		 |
       |200-207        | 40		|333		 |233		 |
       |210	       | 260		|334		 |234		 |
       |211-227        | 40		|335		 |235		 |
       |230	       | 260		|336		 |236		 |
       |231-247        | 40		|337		 |237		 |
       |250	       | 360		|340		 |240		 |
       |251-254        | 40		|341		 |241		 |
       |255	       | 55		|342		 |242		 |
       |256-267        | 40		|343		 |243		 |
       |270	       | 361		|344		 |244		 |
       |271-277        | 40		|345		 |245		 |
       |300	       | 200		|346		 |246		 |
       |301	       | 201		|347		 |247		 |
       |302	       | 202		|350		 |250		 |
       |303	       | 203		|351		 |251		 |
       |304	       | 204		|352		 |252		 |
       |305	       | 205		|353		 |253		 |
       |306	       | 206		|354		 |254		 |
       |307	       | 207		|355		 |255		 |
       |310	       | 210		|356		 |256		 |
       |311	       | 211		|357		 |257		 |
       |312	       | 212		|360		 |340		 |
       |313	       | 213		|361		 |341		 |
       |314	       | 214		|362		 |342		 |
       |315	       | 215		|363		 |343		 |
       |316	       | 216		|364		 |344		 |
       |317	       | 217		|365		 |345		 |
       |320	       | 220		|366		 |346		 |
       |321	       | 221		|367		 |347		 |
       |322	       | 222		|370		 |350		 |
       |323	       | 223		|371		 |351		 |
       |324	       | 224		|372		 |352		 |
       |325	       | 225		|373		 |353		 |
       |326	       | 226		|374		 |354		 |
       |327	       | 227		|375		 |355		 |
       |330	       | 230		|376		 |356		 |
       |331	       | 231		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 1251 to Mac Cyrillic
       For the conversion of MS 1251 to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     | Mac Cyrillic	|   MS 1251	 | Mac Cyrillic  |
       |24	       | 4		|260		 |241		 |
       |200	       | 253		|262		 |247		 |
       |201	       | 256		|263		 |264		 |
       |202	       | 40		|264		 |266		 |
       |203	       | 257		|266		 |246		 |
       |204	       | 327		|267		 |245		 |
       |205	       | 311		|270		 |336		 |
       |206	       | 240		|271		 |334		 |
       |207-211        | 40		|272		 |271		 |
       |212	       | 274		|273		 |310		 |
       |213	       | 40		|274		 |300		 |
       |214	       | 276		|275		 |301		 |
       |215	       | 315		|276		 |317		 |
       |216	       | 40		|277		 |273		 |
       |217	       | 332		|300		 |200		 |
       |220	       | 254		|301		 |201		 |
       |221	       | 324		|302		 |202		 |
       |222	       | 325		|303		 |203		 |
       |223	       | 322		|304		 |204		 |
       |224	       | 323		|305		 |205		 |
       |225	       | 40		|306		 |206		 |
       |226	       | 320		|307		 |207		 |
       |227	       | 321		|310		 |210		 |
       |230	       | 40		|311		 |211		 |
       |231	       | 252		|312		 |212		 |
       |232	       | 275		|313		 |213		 |
       |233	       | 40		|314		 |214		 |
       |234	       | 277		|315		 |215		 |
       |235	       | 316		|316		 |216		 |
       |236	       | 40		|317		 |217		 |
       |237	       | 333		|320		 |220		 |
       |240	       | 312		|321		 |221		 |
       |241	       | 330		|322		 |222		 |
       |242	       | 331		|323		 |223		 |
       |243	       | 267		|324		 |224		 |
       |244	       | 377		|325		 |225		 |
       |245	       | 242		|326		 |226		 |
       |246	       | 40		|327		 |227		 |
       |247	       | 244		|330		 |230		 |
       |250	       | 335		|331		 |231		 |
       |252	       | 270		|332		 |232		 |
       |253	       | 307		|333		 |233		 |
       |254	       | 302		|334		 |234		 |
       |255	       | 55		|335		 |235		 |
       |256	       | 250		|336		 |236		 |
       |257	       | 272		|337		 |237		 |
       |355	       | 316		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						     iconv_1251(5)
All times are GMT -4. The time now is 07:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy