Help with split a list of records into each line with 200 coordinate at a time Post: 303022199

Sponsored Content

Top Forums Shell Programming and Scripting Help with split a list of records into each line with 200 coordinate at a time Post 303022199 by RudiC on Monday 27th of August 2018 10:51:26 AM

08-27-2018

Registered User

Whatever "with 200 coordinate at a time" means, how about

Code:

awk '{TMP = $4; while (TMP > 200) {$3 = $2 + 200 - 1; $4 = 200; print; $2 += 200; TMP -= 200} $3 += TMP; $4 = TMP; print} ' file
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

EDIT: Or, to stay with your nomenclature, try

Code:

awk '{TMP = $4; while (TMP > COORD) {$3 = $2 + COORD - 1; $4 = COORD; print; $2 += COORD; TMP -= COORD} $3 += TMP; $4 = TMP; print} ' COORD=200 file

RudiC

View Public Profile for RudiC

Find all posts by RudiC

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?

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 ->...

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. 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...

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. 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

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

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...

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

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List UID's between 100 and 200

Discussion started by: warlock129

2. UNIX for Dummies Questions & Answers

Split 200.000 files into different subfolders

Discussion started by: diadas

3. UNIX for Dummies Questions & Answers

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

Discussion started by: Atrisa

4. Shell Programming and Scripting

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

Discussion started by: ram2581

5. Shell Programming and Scripting

split records into different files

Discussion started by: HemaV

6. Shell Programming and Scripting

Split records into multiple records

Discussion started by: kmsekhar

7. Shell Programming and Scripting

Split Records

Discussion started by: traininfa

8. Shell Programming and Scripting

Sorting with list, - 2 lists next to 200

Discussion started by: Paul Walker

9. Shell Programming and Scripting

Split records

Discussion started by: Shivdatta