Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

Shell Scripting help

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Shell Scripting help
# 15  
Old 06-24-2019
It's all doable in perl.
Code:
perl -lne 'm#pName="vin"# and @dt=m#dateTime="(.*?)"# and @mis=m#mis>(.*?)</.*?mis>#g and print $dt[0], " , ", join(" & ", @mis)' temp2.txt

One can store the output of a match in an array. And when printing the array let the join function insert separators.
This User Gave Thanks to MadeInGermany For This Post:
nit42
# 16  
Old 06-24-2019
To also fulfill your earlier requirement, here is an addon that also joins multiple <seg> values:
Code:
perl -lne 'm#pName="vin"# and @dt=m#dateTime="(.*?)"# and @mis=m#mis>(.*?)</.*?mis>#g and @seg=m#seg>(.*?)</.*?seg>#g and print $dt[0], ",", join(" & ", @mis), ",", join(" & ", @seg)' temp2.txt

Now I think you should be able to further extend this yourself...
This User Gave Thanks to MadeInGermany For This Post:
nit42
# 17  
Old 07-08-2019
Quote:
Originally Posted by MadeInGermany
To also fulfill your earlier requirement, here is an addon that also joins multiple <seg> values:
Code:
perl -lne 'm#pName="vin"# and @dt=m#dateTime="(.*?)"# and @mis=m#mis>(.*?)</.*?mis>#g and @seg=m#seg>(.*?)</.*?seg>#g and print $dt[0], ",", join(" & ", @mis), ",", join(" & ", @seg)' temp2.txt

Now I think you should be able to further extend this yourself...
Many thanks for this.

I was trying to grep this payload as well using perl but not able to get the expected result.

Code:
<l:ev dateTime="2019-06-14 09:30" pName="vin"> <n:mis>222</n:mis><n:seg>sit</n:seg> <Response><a><ErrorD>Err-116</ErrorD></a><a><ErrorD>Err-117</ErrorD></a>><a><ErrorD>Err-116</ErrorD></a></Response> <Logging><a><ErrorD>Err-116</ErrorD></a><a><ErrorD>Err-117</ErrorD></a>><a><ErrorD>Err-118</ErrorD></a></Logging></l:ev>

Here i was expecting this output like ErrorD to come once only for Response section not for Logging section.
Expected Output:
222,sit,Err-116 & Err-117 & Err-118

For this i was trying these but seems not correct.

Code:
perl -lne 'm#pName="vin"# and @dt=m#dateTime="(.*?)"# and @mis=m#mis>(.*?)</.*?mis>#g and @seg=m#seg>(.*?)</.*?seg>#g and  @MError=m#Response.*?>.*?<.*?ErrorD.*?>(.*?)</.*?ErrorD>.*?</.*?Response>#g  and print $dt[0], ",", join(" & ", @mis), ",", join(" & ", @seg)', ",", join(" & ", @MError)' temp2.txt

perl -lne 'm#pName="vin"# and @dt=m#dateTime="(.*?)"# and @mis=m#mis>(.*?)</.*?mis>#g and @seg=m#seg>(.*?)</.*?seg>#g and  @MError=m#ErrorD.*?>(.*?)</.*?ErrorD>#g  and print $dt[0], ",", join(" & ", @mis), ",", join(" & ", @seg)', ",", join(" & ", @MError)' temp2.txt


Thanks,
Nitish
Last edited by nit42; 07-08-2019 at 09:04 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

2. Shell Programming and Scripting

help me in Shell Scripting

Hi there please have a look at the code..i want to create Using a named pipe. Run a find in the background starting in the working directory While this is happening wait for input from the user to ask him which file to find. If the user does not enter any data in 10 seconds ask the user again.... (1 Reply)
Discussion started by: kattak1511
1 Replies

3. Shell Programming and Scripting

Shell scripting

Hi, if in a network there are lots of PCs connected with either windows or linux as operating system.Then what will be the shell script for the same and also if the PC has linux in it then we have to find if it is occupied or unoccupied. If the PC has windows in it then we have to find if it is... (6 Replies)
Discussion started by: akansha singh
6 Replies

4. UNIX for Dummies Questions & Answers

Shell Scripting

Hey I have a data in the file named as outputFile.txt. The data is in the format 123456,12345678912345,400,09/09/09,INACTIVE. I want this output without commas ie 12345612345678912345400090909INACTIVE. Please tell me what to do and clear explain all the terms, as I am new to it. (6 Replies)
Discussion started by: sampandey31
6 Replies

5. Web Development

Perl scripting or shell scripting?

i am going to study any one of the scripting languages mentioned above(shell 0r perl scripting) . Which is having more scope for a fresher? (1 Reply)
Discussion started by: Anna Hussie
1 Replies

6. What is on Your Mind?

Shell Scripting vs Perl scripting

Gents, I have been working in a Solaris/Unix environment for about 9 months. I took some linux classses online before getting the job. But, I am not very good at scripting. I want to learn how to script. Do you think that I should start with Shell scripting or Perl? I wanted to continue with... (2 Replies)
Discussion started by: Pouchie1
2 Replies

7. Android

Android Scripting Environment: Shell Scripting and Android

I just upgraded to Android 2.2 from 2.1. The GPS issue that was troublesome in 2.1 seems to have been fixed. Some of web browsing seems faster, but it could just be my connection is better today ;) Flash works in some browsers but not very good and it is too slow for Flash apps designed for... (0 Replies)
Discussion started by: Neo
0 Replies

8. What is on Your Mind?

Shell scripting vs Perl scripting

Hi all, I would like to start developping some good scripting skills. Do you think it would be best to start with shell scripting or Perl? I already got a fundation, really basics, in perl. but I am wondering what would be best to be good at first. Can you please help me determine which one to... (14 Replies)
Discussion started by: Pouchie1
14 Replies

9. Shell Programming and Scripting

Call Shell scripting from Perl Scripting.

Hi How to call a shell scripting through a Perl scripting? Actually I need some value from Shell scripting and passes in the Perl scripting. So how can i do this? (2 Replies)
Discussion started by: anupdas
2 Replies

10. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
Login or Register to Ask a Question