jasonchia Posted June 1, 2012 Share Posted June 1, 2012 hi people,i am writing a script to filter desired data from a source file. the script is like thismy scriptfindstr /B "(C) SRC Secure Solutions bv " | findstr /B "===========" | findstr /B " * " | findstr /B "* * * * * * * * * " > (and findstr continue)test.txti try to use findstr?B command which it match the beginning of the line.. input(C) SRC Secure Solutions bv iMenu400 Authorised Options for User 28/05/12 15:39:36 Page 1 ===================================================================================================================================== * * * * * * * * * * * User information . . . . . : User name . . . . . . . . . : ABAX * * * * * * * * * * User text . . . . . . . . . : Beatrice Raffaele * Begin menu . . . . . . . . : *NONE Group jobs . . . . . . . . : 15 End group jobs . . . . . . : *NO Command line on menus . . . : *NO Attention-key program . . . : *ACTIVE Reference user . . . . . . : OPERATOR ===================================================================================================================================== Menu information: Menu . . . . . . . . . . . : ITOP Menu text . . . . . . . . . : ITOP menu for the IBM operators User authority . . . . . . : *REFUSER Reference user authority . : *USE Option Option User Ref.user Group Date Time Number number text authority authority job Activated used used acesses _____________________________________________________________________________________________________________________________________ 1 Job Schedul. BOD 06am EOD:20pm *REFUSER *USE *NO *YES 9 WRKJOBJS *REFUSER *USE *NO *YES 14/05/12 11:54:37 209 10 Work with Job Scheduler (BOD) *REFUSER *USE *NO *YES 14/05/12 5:04:37 156 11 Work with Job Scheduler (EOD) *REFUSER *USE *NO *YES 11/05/12 23:27:57 248 12 Check JS History *REFUSER *USE *NO *YES 13 WRKJOBSCDE *REFUSER *USE *NO *YES 29/02/12 4:10:25 2 15 Save and Restore *REFUSER *USE *NO *YES 20 Save Objects (SAVOBJ) *REFUSER *USE *NO *YES 21 Restore Object (RSTOBJ) *REFUSER *USE *NO *YES 22 Save Library (SAVLIB) *REFUSER *USE *NO *YES 23 Restore Library (RSTLIB) *REFUSER *USE *NO *YES 24 Save restore obj (SAVRSTOBJ) *REFUSER *USE *NO *YES 25 *REFUSER *USE *NO *YES 27 Work with commands *REFUSER *USE *NO *YES 28 Work with BRMS (WRKMEDIBRM *REFUSER *USE *NO *YES 29 Work with object (WRKOBJ) *REFUSER *USE *NO *YES 29/02/12 23:38:06 1 30 Active Jobs (WRKACTJOB) *REFUSER *USE *NO *YES 28/05/12 12:11:10 675 31 MQSeries (WRKMQM) *REFUSER *USE *NO *YES 25/10/11 21:15:30 5 32 Configurat.status (WRKCFGSTS) *REFUSER *USE *NO *YES 33 Submitted Jobs (WRKSBMJOB) *REFUSER *USE *NO *YES 3/08/11 4:03:06 1 34 Object Locks (WRKOBJLCK) *REFUSER *USE *NO *YES 7/06/11 23:53:36 9 35 Work with Job (WRKJOB) *REFUSER *USE *NO *YES 14/05/12 5:08:32 25 36 Work with Writers (WRKWTR) *REFUSER *USE *NO *YES 37 Output Queues (WRKOUTQ) *REFUSER *USE *NO *YES 38 Spool Files (WRKSPLF) *REFUSER *USE *NO *YES 29/02/12 4:58:54 10 39 *REFUSER *USE *NO *YES 40 Device Description (WRKDEVD) *REFUSER *USE *NO *YES 8/01/12 20:53:13 4 41 Work with Libraries(WRKLIB) *REFUSER *USE *NO *YES 27/03/12 15:28:43 5 42 With Subsystems (WRKSBS) *REFUSER *USE *NO *YES 8/01/12 18:18:51 10 (C) SRC Secure Solutions bv iMenu400 Authorised Options for User 28/05/12 15:39:36 Page 2 ===================================================================================================================================== * * * * * * * * * * * User information . . . . . : User name . . . . . . . . . : AGNESP * * * * * * * * * * User text . . . . . . . . . : AGNES L Q POOI * Begin menu . . . . . . . . : MAIN Group jobs . . . . . . . . : 15 End group jobs . . . . . . : *NO Command line on menus . . . : *NO Attention-key program . . . : *ACTIVE Reference user . . . . . . : *MULTIPLE Reference User _____________________________________________________________________________________________________________________________________ ALLUSR Main Menu User GRPBOSECA Securities Admin. GRPBOSECI Securities Admin. GRPBOSECU Securities Admin ===================================================================================================================================== Menu information: Menu . . . . . . . . . . . : BO09 Menu text . . . . . . . . . : BO Ops Exceptional Functions Menu User authority . . . . . . : *REFUSER Reference user authority . : *USE Option Option User Ref.user Group Date Time Number number text authority authority job Activated used used acesses _____________________________________________________________________________________________________________________________________ 1 Exceptional Functions *REFUSER *USE *NO *YES 90 SIGNOFF *REFUSER *USE *NO *YES ===================================================================================================================================== Menu information: Menu . . . . . . . . . . . : BO09001 Menu text . . . . . . . . . : Exceptional Functions User authority . . . . . . : *REFUSER Reference user authority . : *USE Option Option User Ref.user Group Date Time Number number text authority authority job Activated used used acesses _____________________________________________________________________________________________________________________________________ 1 Re-activate *REFUSER *USE *NO *YES 2 Transfer Order In "BAD" Status *REFUSER *USE *NO *YES 90 SIGNOFF *REFUSER *USE *NO *YES ===================================================================================================================================== * * * * * * * * * * * User information . . . . . : User name . . . . . . . . . : SGKANT * * * * * * * * * * User text . . . . . . . . . : SUNNY SEOW PENG KANG * Begin menu . . . . . . . . : MAIN Group jobs . . . . . . . . : 15 End group jobs . . . . . . : *NO Command line on menus . . . : *NO Attention-key program . . . : *ACTIVE Reference user . . . . . . : *MULTIPLE Reference User _____________________________________________________________________________________________________________________________________ ALLUSR Main Menu User GRPMKTFO Front Office Mkting ===================================================================================================================================== Menu information: Menu . . . . . . . . . . . : MAIN Menu text . . . . . . . . . : ABN Amro Singapore User authority . . . . . . : *REFUSER Reference user authority . : *USE Option Option User Ref.user Group Date Time Number number text authority authority job Activated used used acesses _____________________________________________________________________________________________________________________________________ 33 Front Office Main Menu *REFUSER *USE *NO *YES 10/04/12 18:15:34 229 90 SIGNOFF *REFUSER *USE *NO *YES =====================================================================================================================================output(C) SRC Secure Solutions bv iMenu400 Authorised Options for User 28/05/12 15:39:36 Page 1===================================================================================================================================== * ** * * * * * * * * User information . . . . . : User name . . . . . . . . . : ABAX * * * * * * * * * * User text . . . . . . . . . : Beatrice Raffaele * Begin menu . . . . . . . . : *NONE Group jobs . . . . . . . . : 15 End group jobs . . . . . . : *NO Command line on menus . . . : *NO Attention-key program . . . : *ACTIVE Reference user . . . . . . : OPERATOR===================================================================================================================================== * ** * * * * * * * * User information . . . . . : User name . . . . . . . . . : AGNESP * * * * * * * * * * User text . . . . . . . . . : AGNES L Q POOI * Begin menu . . . . . . . . : MAIN Group jobs . . . . . . . . : 15 End group jobs . . . . . . : *NO Command line on menus . . . : *NO Attention-key program . . . : *ACTIVE Reference user . . . . . . : *MULTIPLEReference User_____________________________________________________________________________________________________________________________________ALLUSR Main Menu User GRPBOSECA Securities Admin.GRPBOSECI Securities Admin. GRPBOSECU Securities Admin * ** * * * * * * * * User information . . . . . : User name . . . . . . . . . : SGKANT * * * * * * * * * * User text . . . . . . . . . : SUNNY SEOW PENG KANG * Begin menu . . . . . . . . : MAIN Group jobs . . . . . . . . : 15 End group jobs . . . . . . : *NO Command line on menus . . . : *NO Attention-key program . . . : *ACTIVE Reference user . . . . . . : *MULTIPLEReference User_____________________________________________________________________________________________________________________________________ALLUSR Main Menu User GRPMKTFO Front Office Mkting=====================================================================================================================================i think it doesn't recognize * and space ?!So, any way to extract the required data..i also think about using findstr /v, but this will result in more command which is not efficient.anyone can guide me along about how to implement the code in a more efficiency,,thanks Link to comment Share on other sites More sharing options...
jaclaz Posted June 1, 2012 Share Posted June 1, 2012 So, any way to extract the required data..Can you detail which specific data are you trying to extract? jaclaz Link to comment Share on other sites More sharing options...
bphlpt Posted June 1, 2012 Share Posted June 1, 2012 Are you trying to put in "input" and get out "output"? Is that exact output form required (Why?), or would you rather have a more concise summary of the specific fields you are interested in?Cheers and Regards Link to comment Share on other sites More sharing options...
allen2 Posted June 1, 2012 Share Posted June 1, 2012 Using gawk from the unix tools:gawk -v sb="" "/Menu information:/,/===========/ { if ( $0 ~ /===========/ ) print sb; next } 1" input.txt >output.txt This should almost do what you need because in your output an extra line of "========" is missing if i understood properly : you wanted to remove the lines between one begining with "Menu information:" and one containing only "=====". Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now