Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Copy a string to another file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Copy a string to another file
# 8  
Old 08-19-2017
Quote:
Originally Posted by John K
Thanks Ravinder. So, in your solution, you are asking awk utility to start reading from right to left . Right ? ( $6 being the first field)
Hello John K,

Following is the explanation for solution in more details.
I- Field first will always start from left only.
II- Though you could read fields either from left to right OR right to left.
III- Let's take a look after setting field separator to -F"'|;" and go through all the fields in the line by a loop to see what are the values we have:
Code:
awk -F"'|;" '{for(i=1;i<=NF;i++){print "Field number=",i,"Field value=",$i}}'   Input_file
 
Field number= 1 Field value= UPDATE TAGREF  SET TAG_VAL = NULL  WHERE ATTR_NAME IN   (
Field number= 2 Field value= Span
Field number= 3 Field value= ,
Field number= 4 Field value= SpanUnitOfMeasure
Field number= 5 Field value= )   AND TAG_ID =
Field number= 6 Field value= 1-19KYTMQY
Field number= 7 Field value=
Field number= 8 Field value=
Field number= 1 Field value= UPDATE TAGREF  SET TAG_VAL = NULL  WHERE ATTR_NAME IN   (
Field number= 2 Field value= Span
Field number= 3 Field value= ,
Field number= 4 Field value= SpanUnitOfMeasure
Field number= 5 Field value= )   AND TAG_ID =
Field number= 6 Field value= 1-19KZQV5B
Field number= 7 Field value=
Field number= 8 Field value=
Field number= 1 Field value= UPDATE TAGREF  SET TAG_VAL = NULL  WHERE ATTR_NAME IN   (
Field number= 2 Field value= Span
Field number= 3 Field value= ,
Field number= 4 Field value= SpanUnitOfMeasure
Field number= 5 Field value= )   AND TAG_ID =
Field number= 6 Field value= 1-19N01VZQ
Field number= 7 Field value=
Field number= 8 Field value=

IV- So here you could see above 6th field's value is the one which you need to print.
Let me know if you have any more queries on same.

Thanks,
R. Singh
Last edited by RavinderSingh13; 08-19-2017 at 01:52 AM..
This User Gave Thanks to RavinderSingh13 For This Post:
John K
# 9  
Old 08-21-2017
Thank You for the brilliant demo , Ravinder.

I didn't know that awk can have multiple field delimiters . So, -F"'|;" means , the field delimiter can be either a single quote or a semicolon .
Why was semicolon included as the delimiter ? Because, the following command without semicolon as the delimiter works fine too.
Code:
$ awk -F"'" '{print $6}' somePattern.txt
1-19KYTMQY
1-19KZQV5B
1-19N01VZQ
1-18N01VZQ

# 10  
Old 08-21-2017
Quote:
Originally Posted by John K
Thank You for the brilliant demo , Ravinder.
I didn't know that awk can have multiple field delimiters . So, -F"'|;" means , the field delimiter can be either a single quote or a semicolon .
Why was semicolon included as the delimiter ? Because, the following command without semicolon as the delimiter works fine too.
Code:
$ awk -F"'" '{print $6}' somePattern.txt
1-19KYTMQY
1-19KZQV5B
1-19N01VZQ
1-18N01VZQ

Hello John K,

Yes, in this case you can remove ;. But in any other cases you could use multiple delimiters as per your requirements too.

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
John K
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