Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: String copy
Top Forums Shell Programming and Scripting String copy Post 302507962 by ctsgnb on Friday 25th of March 2011 09:24:05 AM
Old 03-25-2011
Once you have colon delimited your file, adding the last column is just piece of cake

Code:
# cat outfile
Castillo:d'Canena Extra Virgin Arbequina Olive Oil (250ml) 8 10000
Castillo:d'Canena Extra Virgin Picual Olive Oil (250ml) 8 10000
Farchioni:Il Casolare Olive Oil Extra Virgin (1L) 8 10000
Filippo Berio:Extra Virgin Olive Oil (250ml) 8 10000
Filippo Berio:Extra Virgin Olive Oil (500ml) 8 10000
Filippo Berio:Extra Virgin Olive Oil (750ml) 8 10000
Filippo Berio:Extra Virgin Olive Oil (1L) 8 10000
Filippo Berio:Extra Virgin Olive Oil Special Selection (250ml) 8 10000
Filippo Berio:Extra Virgin Olive Oil Tin (1L) 8 10000
Filippo Berio:Gusto Fruttato Extra Virgin Olive Oil (500ml) 8 10000
Filippo Berio:Mild & Light Olive Oil (250ml) 8 10000
Filippo Berio:Mild & Light Olive Oil (500ml) 8 10000
Filippo Berio:Mild & Light Olive Oil (1L) 8 10000

Code:
# awk -F: '{print $0":"$1}' outfile

or
Code:
# awk -F: '{print $0,$1}' OFS=: outfile
Castillo:d'Canena Extra Virgin Arbequina Olive Oil (250ml) 8 10000:Castillo
Castillo:d'Canena Extra Virgin Picual Olive Oil (250ml) 8 10000:Castillo
Farchioni:Il Casolare Olive Oil Extra Virgin (1L) 8 10000:Farchioni
Filippo Berio:Extra Virgin Olive Oil (250ml) 8 10000:Filippo Berio
Filippo Berio:Extra Virgin Olive Oil (500ml) 8 10000:Filippo Berio
Filippo Berio:Extra Virgin Olive Oil (750ml) 8 10000:Filippo Berio
Filippo Berio:Extra Virgin Olive Oil (1L) 8 10000:Filippo Berio
Filippo Berio:Extra Virgin Olive Oil Special Selection (250ml) 8 10000:Filippo Berio
Filippo Berio:Extra Virgin Olive Oil Tin (1L) 8 10000:Filippo Berio
Filippo Berio:Gusto Fruttato Extra Virgin Olive Oil (500ml) 8 10000:Filippo Berio
Filippo Berio:Mild & Light Olive Oil (250ml) 8 10000:Filippo Berio
Filippo Berio:Mild & Light Olive Oil (500ml) 8 10000:Filippo Berio
Filippo Berio:Mild & Light Olive Oil (1L) 8 10000:Filippo Berio

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Copy / string.

I'm trying to get a script to copy a url then put it in a different place in the file. Example is currently the script goes to a site takes the urls on it and then puts them into an html file. Only thing is I want to make them into links. So currently lynx goes to the page takes out the urls.... (6 Replies)
Discussion started by: Paulw0t
6 Replies

2. UNIX for Dummies Questions & Answers

Copy or Grep all text below a string

Hello, I am trying to copy all the text from a file below a search string... For example i want to grep all text below the word sure: UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! ... (2 Replies)
Discussion started by: aliaa2a
2 Replies

3. Shell Programming and Scripting

find a string and copy the string after that

Hi! just want to seek help on this: i have a file wherein i want to find a string and copy the string after that and paste that other string to a new file. ex: TOTAL 123456 find "TOTAL" and copy "123456" and paste "123456" to a new file NOTE: there are many "TOTAL" strings on that... (12 Replies)
Discussion started by: kingpeejay
12 Replies

4. Shell Programming and Scripting

how to copy one string in ksh into another

Hi Does anybody know if there is a utility/command in ksh which would allow to copy/insert the contents of one string into certain positions of the other? for example: A=" ABCDEF " B="HHH" I need to insert contents of string "B" into string "A" from position 3 to 5, so... (3 Replies)
Discussion started by: aoussenko
3 Replies

5. Shell Programming and Scripting

Copy-paste string automatically

Hi i'm not really sure if it's possible or not in bash. Basically I want to convert a ssh key created with ssh-keygen to putty format. The problem is that puttygen doesn't have an option for supplying passphrase in batch mode so it must be entered manually. For sskey generated with ssh-keygen i use... (2 Replies)
Discussion started by: ktm
2 Replies

6. Programming

String copy in C language

Hello, I have a text file (FILE.txt) that contains the following information: userAxxx.name@email.com userA userBxxx.name@email.com userB userxxCx.name@email.com userC and more.... in scripting, I can easily do a grep and awk to store an email info into a string... (6 Replies)
Discussion started by: tqlam
6 Replies

7. Shell Programming and Scripting

input a string and copy lines from a file with that string on it

i have a file1 with many lines. i have a script that will let me input a string. for example, APPLE. what i need to do is to copy all lines from file1 where i can find APPLE or any string that i specify and paste in on file 2 thanks in advance! (4 Replies)
Discussion started by: engr.jay
4 Replies

8. Shell Programming and Scripting

Help on Script of Copy String from column

Hello, My DATA: PLOKIJ1234G 12 13 14 15 PLOKIJ1234E 12 13 14 15 PLOKIJ1234F 12 22 33 44 IJNUHB12346 55 66 77 88 IJNUHB12347 32 34 45 67 IJUHU345D 23 23 22 33 IJUHYG23E 11 24 23 23 IJUHYG23F 77 88 99 00 output: PLOKIJ1234 PLOKIJ1234G 12 13 14 15 PLOKIJ1234... (11 Replies)
Discussion started by: asavaliya
11 Replies

9. Shell Programming and Scripting

Copy last third char form string

HI Input A.txt ABC907 ABC907_1B_9 ABC985 ABC985_1A_9 ABC985 ABC985_1B_9 ABC985 ABC985_1C_9 ABC05037 ABC05037_1A_9 ABC05037 ABC05037_1B_9 Base of column 2 last third char. If It is A the 1,if B then 2 If C then 3 File B.txt ABC907 ABC907_1B_9 2 ABC985 ABC985_1A_9 1 ABC985... (8 Replies)
Discussion started by: asavaliya
8 Replies

10. Shell Programming and Scripting

Copy a string to another file

OS version: RHEL 6.7 Shell : Bash I have a file like below. It has 500K lines. I want to extract TAG_IDs shown in single quote at the end to copied to another file. As if I had copied the TAG_IDs using block select (Column Select) in modern text editor $ cat file.txt UPDATE TAGREF SET... (9 Replies)
Discussion started by: John K
9 Replies

LEARN ABOUT OPENDARWIN

column

COLUMN(1)						    BSD General Commands Manual 						 COLUMN(1)

NAME

     column -- columnate lists

SYNOPSIS

     column [-tx] [-c columns] [-s sep] [file ...]

DESCRIPTION

     The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file operands, or, by
     default, from the standard input.	Empty lines are ignored.

     The options are as follows:

     -c      Output is formatted for a display columns wide.

     -s      Specify a set of characters to be used to delimit columns for the -t option.

     -t      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default, or with
	     the characters supplied using the -s option.  Useful for pretty-printing displays.

     -x      Fill columns before filling rows.

DIAGNOSTICS

     The column utility exits 0 on success, and >0 if an error occurs.

ENVIRONMENT

     COLUMNS  The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

	   (printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ; 
	   printf "HH:MM/YEAR NAME
" ; 
	   ls -l | sed 1d) | column -t

SEE ALSO

     colrm(1), ls(1), paste(1), sort(1)

HISTORY

     The column command appeared in 4.3BSD-Reno.

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