Question

10

How do I delete everything after second occurrence of quotes using the command line?

rated 0 times [ 10] [ 0] / answers: 1 / hits: 10541 / 1 Year ago, sat, april 15, 2023, 4:52:56

I have this store in a variable



   sCellEventTrap-03-28 TRAP-TYPE  -- CAC Code: 00

        ENTERPRISE compaq

        VARIABLES  { scellNameDateTime,

                     scellSWComponent,

                     scellECode,

                     scellCAC,

                     scellEIP}

        DESCRIPTION

             "Severity: Normal -- informational in nature. A physical disk drive has experienced an ID block inconsistency during a periodic drive check."

           --#TYPE      "StorageCell Event"

           --#SUMMARY   "SCellName-TimeDate %s : SWCID %d : ECode: %d : CAC %d : EIP %d."

           --#ARGUMENTS {0,1,2,3,4,}

           --#SEVERITY  INFORMATIONAL

           --#TIMEINDEX 136

           --#STATE     WARNING

        ::= 13600808

I am to cut everything till second occurrence of ". So that would give me:



 sCellEventTrap-03-28 TRAP-TYPE  -- CAC Code: 00

        ENTERPRISE compaq

        VARIABLES  { scellNameDateTime,

                     scellSWComponent,

                     scellECode,

                     scellCAC,

                     scellEIP}

        DESCRIPTION

             "Severity: Normal -- informational in nature. A physical disk drive has experienced an ID block inconsistency during a periodic drive check."

Another Example



    genericSanEvent TRAP-TYPE

        ENTERPRISE hpSanManager

        VARIABLES  { severityLevel, category, id,

                     msgString, contactName, contactEmail,

                     contactWorkPhone, contactHomePhone, 

                     contactPager, contactFax }

        DESCRIPTION

                        "A generic SAN event has occurred.  The variables are:

                            severityLevel - the event severity level;

                            category - Category of the event being reported;

                            code - ID of the event in the given category;

                            msgString - the message string describing

                                the event;

                            contactName - the name of the individual

                                to be notified of the event;

                            contactEmail - the e-mail address of the

                                individual referred to in contactName;

                            contactWorkPhone - the work phone number

                                of the individual referred to in 

                                contactName;

                            contactHomePhone - the home phone number

                                of the individual referred to in 

                                contactName;

                            contactPager - the pager number of the 

                                individual referred to in contactName;

                            contactFax - the FAX number of the individual

                                 referred to in contactName"

     -- The following are attributes used by xnmloadmib for improved formatting

     --#TYPE "OV SAM SAN Event"

     --#SUMMARY "OV SAM SAN Event, Category/Id: %d/%d, Msg: %d  Severity: %d  Contact: %d"

     --#ARGUMENTS {1,2,3,0,4}

     --#SEVERITY CRITICAL

     --#GENERIC 6

     --#CATEGORY "Application Alert Events"

     --#SOURCE_ID "T"

        ::= 1

Output for this example should be :



    genericSanEvent TRAP-TYPE

        ENTERPRISE hpSanManager

        VARIABLES  { severityLevel, category, id,

                     msgString, contactName, contactEmail,

                     contactWorkPhone, contactHomePhone, 

                     contactPager, contactFax }

        DESCRIPTION

                        "A generic SAN event has occurred.  The variables are:

                            severityLevel - the event severity level;

                            category - Category of the event being reported;

                            code - ID of the event in the given category;

                            msgString - the message string describing

                                the event;

                            contactName - the name of the individual

                                to be notified of the event;

                            contactEmail - the e-mail address of the

                                individual referred to in contactName;

                            contactWorkPhone - the work phone number

                                of the individual referred to in 

                                contactName;

                            contactHomePhone - the home phone number

                                of the individual referred to in 

                                contactName;

                            contactPager - the pager number of the 

                                individual referred to in contactName;

                            contactFax - the FAX number of the individual

                                 referred to in contactName"

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

algicuade

Add To Favorites

Follow

Total Points: 317

Total Questions: 89

Total Answers: 106

Location: Saint Pierre and Miquelon

Member since Fri, Jan 28, 2022

2 Years ago

algicuade questions

1 bash: do not show the part of the line that is in the search terms of the grep command

Fri, Jul 22, 22, 04:10, 2 Years ago

1 ERR trap gets a return code of 1; there is no stderr text I can find for a statement "(( kIdx++ ))" why?

Fri, Jul 1, 22, 11:59, 2 Years ago

1 How to read with timeout without making bash consider it an error?

Wed, Jul 13, 22, 09:04, 2 Years ago

1 Not able to use propietary nvidia drivers properly on Ubuntu 21.04

Tue, Mar 14, 23, 01:07, 1 Year ago

1 iPhone connection: is it possible to change some settings?

Tue, Apr 5, 22, 19:04, 2 Years ago

View All

answered 1 Year ago rieency · Accepted Answer

Using awk:

awk -v RS='"' -v ORS='"' 'NR==1{print} NR==2{print; printf"

";exit}' file

This sets the record separator to ". So, we want to print the first two records and then we are done. In more detail:

-v RS='"'

This sets the input record separator to a double quote.

-v ORS='"'

This sets the out record separator to a double quote.

NR==1{print}

This tells awk to print the first line.

NR==2{print; printf" ";exit}

This tells awk to print the second line, then print a newline character, and then exit.

Using sed

sed -r 'H;1h;$!d;x; s/(([^"]*"){2}).*/1/' file

This reads the whole file in at once. So, if the file is huge, don't use this approach. It works as follows:

H;1h;$!d;x

This is a useful sed idiom: it reads the whole file in at once.

s/(([^"]*"){2}).*/1/

This looks for the second " and then deletes all text which follows the second quote.

The regex (([^"]*"){2}) captures all text up to and including the second double quote and saves it in group 1. The regex .* captures everything that follows to the end of the file. The replacement text is group 1, 1.