EmadGirgis
asked on
How to extract a substr
need to extract the path of the file between the "" from the data below! I need this urgently!
23-Oct.16:43 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetTaxSe gAbsorbSQL Statement. h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetTrans fersInfo1S QLStatemen t.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetPfcEs sAirSvcSQL Statement. h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:40 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetPaxTy peSQLState ment.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:40 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetPaxTy peMatrixSQ LStatement .h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetTrfIn hibSQLStat ement.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:28 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetZoneS QLStatemen t.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetPfcEx emptionSQL Statement. h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetPFCSQ LStatement .h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetTpdPs rSQLStatem ent.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetRouti ngSQLState ment.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:43 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetTaxCo deSQLState ment.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetVendX refSQLStat ement.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:45 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetYQYRF eesSQLStat ement.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetRouti ngForMarke tSQLStatem ent.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:43 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:40 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:40 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:28 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:43 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:44 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:45 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
KOSARAJUS:~ KOSARAJU$ cat test.log
23-Oct.16:43 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetTaxSe gAbsorbSQL Statement. h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q ueries/Que ryGetRouti ngForMarke tSQLStatem ent.h" from /main/atsev2_Integration/O racleTaxV2 /0 (unreserved)
KOSARAJUS:~ KOSARAJU$ tail -f test.log | cut -d " " -f 9
"/vobs/atseintl/DBAccess/Q ueries/Que ryGetTaxSe gAbsorbSQL Statement. h"
"/vobs/atseintl/DBAccess/Q ueries/Que ryGetRouti ngForMarke tSQLStatem ent.h"
23-Oct.16:43 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
23-Oct.16:41 sg912681 checkout version "/vobs/atseintl/DBAccess/Q
KOSARAJUS:~ KOSARAJU$ tail -f test.log | cut -d " " -f 9
"/vobs/atseintl/DBAccess/Q
"/vobs/atseintl/DBAccess/Q
Using perl:
perl -an -F/\"/ -e 'print "$F[1]\n"' test1.txt
Or as a perl program instead of command line:
open(my $in, "<file.txt") or die "Could not open file: $!\n";
while(<$in>) {
my @F=split/"/;
print "$F[1]\n";
}
close($in);
perl -an -F/\"/ -e 'print "$F[1]\n"' test1.txt
Or as a perl program instead of command line:
open(my $in, "<file.txt") or die "Could not open file: $!\n";
while(<$in>) {
my @F=split/"/;
print "$F[1]\n";
}
close($in);
awk -F'"' filename
filename is the file that contains the lines you posted