Copy a string to another file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Copy a string to another file
# 1  
Old 08-18-2017
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
Code:
UPDATE TAGREF  SET TAG_VAL = NULL  WHERE ATTR_NAME IN   ('Span', 'SpanUnitOfMeasure')   AND TAG_ID = '1-19KYTMQY';
UPDATE TAGREF  SET TAG_VAL = NULL  WHERE ATTR_NAME IN   ('Span', 'SpanUnitOfMeasure')   AND TAG_ID = '1-19KZQV5B';
UPDATE TAGREF  SET TAG_VAL = NULL  WHERE ATTR_NAME IN   ('Span', 'SpanUnitOfMeasure')   AND TAG_ID = '1-19N01VZQ';
.
.
.
.
.

expected output in the output file (with or without single quotes is fine)

Code:
1-19KYTMQY
1-19KZQV5B
1-19N01VZQ
.
.
.
.

# 2  
Old 08-18-2017
Code:
awk '{print $NF}' file
'1-19KYTMQY';
'1-19KZQV5B';
'1-19N01VZQ';

This User Gave Thanks to RudiC For This Post:
# 3  
Old 08-18-2017
Hello John K,

Could you please try following too(without quotes etc).
Code:
awk -F"'|;" '{print $6}'   Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
# 4  
Old 08-18-2017
Hi Ravinder,
Thank You. What is $6 ?

Hi Rudic,
Thank You. What does NF do ?
# 5  
Old 08-18-2017
man awk:
Quote:
7. Builtin-variables
The following variables are built-in and initialized before program execution.
.
.
.
NF number of fields in the current record.
In awk, Fields are numbered 1 .. NF, so $1 references the first field, and $NF the last one.
This User Gave Thanks to RudiC For This Post:
# 6  
Old 08-18-2017
Quote:
Originally Posted by John K
Hi Ravinder,
Thank You. What is $6 ?
Hi Rudic,
Thank You. What does NF do ?
Hello John K,

In awk language $ means value of any field(we could setup field's separator as per our need like in my solution I have made them to '; and in Rudi's case it is default which is space), so $16 means first field of the line and NF denotes the number of fields in a line, which will print the value of last field

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
# 7  
Old 08-18-2017
Thanks Ravinder. So, in your solution, you are asking awk utility to start reading from right to left . Right ? ( $6 being the first field)
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find string in XML file, copy contents of section

I am new, really new to bash scripts. I want to search an XML file for a certain string, say "1234567890" Once found, I want to copy the entire contents from the previous instance of the string "Entity" to the next instance of "/Entity" to a txt file. And then continue searching for the... (4 Replies)
Discussion started by: jrfiol
4 Replies

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

3. Shell Programming and Scripting

String copy

Hi guys I've got two columns, PRODUCT and BRAND, the Brand column currently has the first word of each product, I've acheived this by using SED to copy the first word of the PRODUCT column, however you run into trouble when the brand has more than one word, i.e. 'Weight Watchers'. Is there... (22 Replies)
Discussion started by: mrpugster
22 Replies

4. Shell Programming and Scripting

Search multiple strings on a file and copy the string next to it

I tried awk for this, but failed <or my code is not correct? I dont know>. Can anyone help me on this? ---------- Post updated at 08:34 PM ---------- Previous update was at 08:29 PM ---------- my working file looks like this: <empty> <empty> <empty> NAME :ABC AGE :15 GENDER... (6 Replies)
Discussion started by: kingpeejay
6 Replies

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

6. Shell Programming and Scripting

How do I search first&second string & copy all content between them to other file?

Hi All, How do I search first string & second string and copy all content between them from one file to another file? Please help me.. Thanks In Advance. Regards, Pankaj (12 Replies)
Discussion started by: pankajp
12 Replies

7. Shell Programming and Scripting

Copy string from files into new file

I'm trying to copy a string (myame@yahoo.com) from multiple files and save them to a new file. This is what's I've gathered so far: sed 's/string/g' file.txt > output.txt Not sure how to run this on multiple files and extract just the email address found in each file. Any help would be... (2 Replies)
Discussion started by: rdell
2 Replies

8. UNIX for Advanced & Expert Users

How to copy a string to a text file

I am using the following command to email a tex file as an attachment- cat mailtext.txt | elm -s "Subject" emailAddr where content of mailtext.txt is - "Body of email" This will attach foo.txt with the email. My problem is that the file foo.txt is ceated dynamically everytime with a... (5 Replies)
Discussion started by: hpuxlxboy
5 Replies

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

10. UNIX for Advanced & Expert Users

find and copy string in a file

Hello there I need to find a string in an file, and then copy to a new file from the previous 6 lines to 41 lines after the string. So, what i need to do , and just don't know how, is to find the string and copy 48 lines where the string would be in the 7th line. I don't know if i can do it with... (10 Replies)
Discussion started by: vascobrito
10 Replies
Login or Register to Ask a Question