hi people, i am writing a script to filter desired data from a source file. the script is like this my script findstr /B "(C) SRC Secure Solutions bv " | findstr /B "===========" | findstr /B " * " | findstr /B "* * * * * * * * * " > (and findstr continue)test.txt i 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 . . . . . . : *MULTIPLE Reference 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 . . . . . . : *MULTIPLE Reference 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
