Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Copy and paste data

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Copy and paste data
# 8  
Old 08-01-2012
we can copy the entire line, remove the first column, and paste that back with the first column of new line. this is one way to preserve formatting.

your matching modifications are wrong again sadly. the substr here starts at the 8th character. so here, n would be 20008, 21895 etc.. if you want to match just last N characters, use substr($1,length($1)-N+1).

Code:
awk '{n=0+substr($1,length($1)-3)} n==8 {copy=$0;sub($1,"",copy)} n>=2011 && n<=2012 {$0=$1 copy} 1' input

# 9  
Old 08-02-2012
try
Code:
awk '{val=0+substr($1,length($1)-3,4);if(val==8){print;$1=x;y=$0}else{if(val>=1895&&val<=2012){print $1 y}else{print}}}' input_file

and output is
Code:
XX123450008 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
XX123451895 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
......
XX123452012 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
......
XX123460008 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
XX123461895 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
.....
XX123462012 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x
......

if output is not as per your requirement then provide sample input data and desired output
# 10  
Old 08-02-2012
The input
Code:
XXYYYYYYY0008   45.5   49.4   56.6   62.9   71.0   77.9   80.9   80.1   74.9   64.0   55.0   47.8   63.8

The output
Code:
XXYYYYYYY1895 45.5 49.4 56.6 62.9 71.0 77.9 80.9 80.1 74.9 64.0 55.0 47.8 63.8

# 11  
Old 08-02-2012
The output you want only has one space, even though you just asked for three?
Code:
awk -v OFS="   "

# 12  
Old 08-03-2012
Quote:
Originally Posted by Corona688
The output you want only has one space, even though you just asked for three?
Code:
awk -v OFS="   "


Im not certain on the use of OFS. Where should I insert that into the script?

Code:
awk '{val=0+substr($1,length($1)-3,4);if(val==8){print;$1=x;y=$0}else{if(val>=2011&&val<=2012){print $1 y}else{print}}}'

# 13  
Old 08-03-2012
Right after the awk, but before awk's any other parameters. Exactly where I put it iow.
# 14  
Old 08-04-2012
please provide more sample data for input and output. With one line of sample data its not clear what exactly you are looking for
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Copy/paste in vi editor

Hello guys, I am trying to copy a line in vi editor and paste it with below commands but paste command is not working and instead of paste action prints the p character!! I should also mention that the server is Solaris... 1) crontab -e 2) j to move down 3) yy to copy the line 4) o to... (4 Replies)
Discussion started by: Newman
4 Replies

2. Shell Programming and Scripting

Copy n paste n times

I have one mainframe copy book where I want to copy n times depend on occurs which mention below. Example: Below highlighted row mention “occurs 2 times” so I need to copy 2 times till next label 10. C14992 10 FILLER PIC X(2835). 01 ... (7 Replies)
Discussion started by: srivalli
7 Replies

3. Shell Programming and Scripting

Copy and Paste to a new document

Hello, I am quite new to shell scripting so don't know all the tools available. What I'm trying to do is open a file optimal.txt search for objectiveValue and copy the number in quotes next to it. e.g. ... solutionName="incumbent" solutionIndex="-1" objectiveValue="13246" ... (6 Replies)
Discussion started by: StephanR
6 Replies

4. UNIX for Dummies Questions & Answers

Copy/Paste in Vi editor

Dear All, I have a file containing 12 lines. First 3 lines have 9 values and the remaining 9 lines with no values. I was trying to copy and paste these 9 values of the first 3 lines into last 9 lines simultaneously as A=1.491331, B=1.539000 ..... but I don't know how to cope with this... (9 Replies)
Discussion started by: sullah
9 Replies

5. UNIX for Dummies Questions & Answers

vi copy/paste problem

I'm having a problem copy/pasting from a txt file in windows to vi. What happens is I copy a chunk of text, go to the putty terminal, go into insert mode, and right click, and it will stop pasting at a random point and freeze up. Nothing I do gets out of it. This only happens on my account... (1 Reply)
Discussion started by: solidarity
1 Replies

6. Shell Programming and Scripting

sed copy paste

Hello, I have this path and file: /dir/dir/dir/dir/dir/dir/dir/dir/dir/THIS_SPOT/fle.txt I want to end up with: /dir/dir/dir/dir/dir/dir/dir/dir/dir/THIS_SPOT/fle.txtTHIS_SPOT Take the dir after the 10th slash, add a tab at the end and paste the dir it copied. Thanks (4 Replies)
Discussion started by: crowman
4 Replies

7. UNIX for Dummies Questions & Answers

Copy/Paste data in files

Hi, I want to put the following values into Variables R2=0.999863 , V2=118.870318 , D2=-178.887511 and so on. There are six values for each variable R2-R8, V2-V8 and D2-D8, total of 18 values for all the variables. Can any one help me to copy and paste all the values in their respective... (2 Replies)
Discussion started by: sullah
2 Replies

8. Shell Programming and Scripting

copy/paste with awk

Hi everybody, I have two XML files. I am working on a script that could copy and paste the contents of the first xml file to the desired location in the second xml file. Here is my first XML file. This is the second XML file. Finaly, I wnat to obtain something like that : ... (2 Replies)
Discussion started by: lsaas
2 Replies

9. Shell Programming and Scripting

Search, copy and paste

Can i search in a file for more than one string at a time? And copy the next string after that and paste it in column style? Is it possible? Thanks! (4 Replies)
Discussion started by: kingpeejay
4 Replies

10. UNIX Desktop Questions & Answers

Cut, Copy and Paste with X

One of the things that I have learned to take for granted in the Win32 world is the cut, copy and paste hotkeys of ^X, ^C and ^V. I use these keys all the time under Win32 to copy and paste information from one GUI into another GUI. My question is, does X have a similiar standard? ... (4 Replies)
Discussion started by: auswipe
4 Replies
Login or Register to Ask a Question