Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to modify the file mentioned in the Message details ?

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to modify the file mentioned in the Message details ?
# 1  
Old 12-15-2015
How to modify the file mentioned in the Message details ?
i have a below file
Code:
   state : CONNECTED ;
   state : CONNECTED  ;
   state : CONNECTED ;
   Rno  :  5554f1d2-6f1b
   Rno  :  10587563-4181
   Rno  :  be6312f7-b4df

the entire content in the fileis obtained by making two seperate Curl calls( one curl call gives me state when i grep the curl call with state and another curl call will give me Rno when i grep with Rno).
Now MY Question is i want the file in the below format .

Code:
   state : CONNECTED , Rno : 5554f1d2
   state : CONNECTED , Rno : 10587563
   state : CONNECTED , Rno : be6312f7 .

How can i get it in this format ?
And also after getting the file in this format my next action would be
depending upon the value of state ( it might me CONNECTED or disconnected ) i would like to fetch the corresponding Rno .

Moderator's Comments:
Mod Comment edit by bakunin: When we asked you to use CODE-tagswe really meant it. This is not optional!
Last edited by bakunin; 12-15-2015 at 11:31 AM..
# 2  
Old 12-15-2015
Please use code tags as required by forum rules!

This is a very vague specification. Based on wild guessing, this might work (untested):
Code:
curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "CONNECTED"

# 3  
Old 12-15-2015
Thanks it did work !!
but it did not address my full question .
Next as these have "" and spaces in between
i.e

Code:
"state" : "CONNECTED",,  "Rno" : "5554f1d2-6f1b-4e74-9ab2-dfe2c1f16dfd"
"state" : "CONNECTED",,  "Rno" : "10587563-4181-4c6e-8862-2570093f42de"
"state" : "CONNECTED",,  "Rno" : "be6312f7-b4df-4120-86de-cddad46743a8"
"state" : "DISCONNECTED",,  "Rno" : "59a71bc0-1d40-4596-901c-24fb710a8ccc"

now the rquirement is actually like if state is Disconnected then i want to fetch that respective Rno .

So i will be using the below command
Code:
curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected"

Now i want Respective UUID ? How do i further enhance the command ?
This Uuuid will be used in another curl command as an input.

Moderator's Comments:
Mod Comment edit by bakunin: see below, CODE-TAGS, PLEASE!
Last edited by bakunin; 12-15-2015 at 11:32 AM..
# 4  
Old 12-15-2015
Moderator's Comments:
Mod Comment First off: you have been asked to use CODE-tags when you accepted the rules of the forum, you have been asked to do so when you opened a new thread and you have been asked to do so by RudiC. You must have seen at least the last request because you directly answered it.

As a hopefully helpful advice to you I'd like to offer the following: paying only partial attention to what you read on screen is not a trait becoming to a systems administrator.

Second: this forum is marked "How to Post in The UNIX and Linux Forums" and is for organisational questions only. This is not a forum for technical questions at all. Please take more care in selecting the correct forum to post to in the future. I will move this thread to where it belongs.


bakunin
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How can I retrieve the matching records from data file mentioned?

XYZNA0000778800Z 16123000012300321000000008000000000000000 16124000012300322000000007000000000000000 17234000012300323000000005000000000000000 17345000012300324000000004000000000000000 17456000012300325000000003000000000000000 9 XYZNA0000778900Z 16123000012300321000000008000000000000000... (8 Replies)
Discussion started by: later_troy
8 Replies

2. Shell Programming and Scripting

Extract sentence and its details from a text file based on another file of sentences

Hi I have two text files. The first file is TEXTFILEONE.txt as given below: <Text Text_ID="10155645315851111_10155645333076543" From="460350337461111" Created="2011-03-16T17:05:37+0000" use_count="123">This is the first text</Text> <Text Text_ID="10155645315851111_10155645317023456"... (7 Replies)
Discussion started by: my_Perl
7 Replies

3. Shell Programming and Scripting

Extract data according to keys from filename mentioned in file

Hello experts, I want to join a file with files whosE names are mentioned in one of the columns of the same file. File 1 t1,a,b,file number 1 t1,a,c,file number 1 t2,c,d,file number 2 t2,c,e,file number 2 t2,c,f,file number 2 t2,c,g,file number 2 t3,e,f,file number 3 file number 1... (3 Replies)
Discussion started by: ritakadm
3 Replies

4. Emergency UNIX and Linux Support

Getting details from sudoers file

Hi, I need the details of which ids belong to the sudoers file, and which groups these ids belong to. Can anyone suggest a way to derive that information into a flat file please? G (4 Replies)
Discussion started by: ggayathri
4 Replies

5. Shell Programming and Scripting

Details within file

Hi, I am trying to write a script with goes through thousands of XML documents to pull out the values for a particular tag to a .txt file. For example I have file1.xml file2.xml file3.xml . . . fileN.xml All these files have a tag called <systemID>. The value that sits within... (6 Replies)
Discussion started by: Chor419
6 Replies

6. Shell Programming and Scripting

Modify a file by another file: add new line and variable after string is found

hello, I have problem with writing/adjusting a shell script. I searched forum and unfortunately couldn't write scipt based on the information I found. I never wtire such so it's hard for me and I do need to modify one script immediately. case looks like: 1. 'file' that needs to be modified... (3 Replies)
Discussion started by: bipbip
3 Replies

7. UNIX for Dummies Questions & Answers

at -l doesnt give details of the scheduled job. How to get the details?

I have scheduled couple of shell scripts to run using 'at' command. The o/p of at -l is: $ at -l 1320904800.a Thu Nov 10 01:00:00 2011 1320894000.a Wed Nov 9 22:00:00 2011 1320876000.a Wed Nov 9 17:00:00 2011 $ uname -a SunOS dc2prcrptetl2 5.9 Generic_122300-54 sun4u sparc... (2 Replies)
Discussion started by: superparticle
2 Replies

8. Shell Programming and Scripting

Not able to make the file size 0 with the mentioned script

#!/bin/sh ########################################################################################################## #This script is being used for AOK application for cleaning up the .out files and zip it under logs directory. # IBM # Created #For pdocap201/pdoca202 .out files for AOK #1.... (3 Replies)
Discussion started by: mridul10_crj
3 Replies

9. UNIX for Dummies Questions & Answers

Script for parsing details in a log file to a seperate file

Hi Experts, Im a new bee for scripting, I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Discussion started by: pingnagan
2 Replies

10. Shell Programming and Scripting

i want to extract details for particular file

Hi i have following file uuid ( RO) : 62701790-60da-dd9a-669d-a563aac1c435 host-uuid ( RO): 5f3f668d-a7c7-4e5f-a4a6-6e90fafb50ed sr-uuid ( RO): 62103d07-e0aa-acf3-2d9f-414ad3377bd0 device-config (MRO): location: /dev/xapi/block ... (6 Replies)
Discussion started by: bp_vardhaman
6 Replies
Login or Register to Ask a Question