OraFAQ Forum: Unix » pattern search in unix

Home » Infrastructure » Unix » pattern search in unix (SunOS )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pattern search in unix [message #652192]

Fri, 03 June 2016 18:55

namitanamburi
Messages: 35
Registered: March 2009

Member

Please look at the code below.

 if [ $WRITE_TO_FILE = Y ]; then
      Copyfiles $DB_SERVER:$OUT_DIR/?????_?????_${PGM_NAME}_${TIMESTAMP}_summary.txt $OUT_DIR -p
   fi

So above code will bring files like below........

MBR09_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt

however I need files

MB_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
MBR_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
MBR8_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt

The first string before _ can be 2 or more than 2 characters(sucha s MB, MBR, MBR8), above code will bring back only MBR08 as ????? which means it is looking for 5 characters.

Please help.

Report message to a moderator

Re: pattern search in unix [message #652195 is a reply to message #652192]

Fri, 03 June 2016 19:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

magvivek@kalyani#ls -lart *.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MB_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MBr_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MBr9_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MB09_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:30 MBr09_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
magvivek@kalyani#ls -alrt {??,???,????,?????}_?????_*
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MB_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MBr_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MBr9_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:29 MB09_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt
-rw-r--r--  1 magvivek  staff  0 Jun  3 20:30 MBr09_CTRT6_pkg-get-mbr-contract_20160602102003_summary.txt

Report message to a moderator

Re: pattern search in unix [message #652303 is a reply to message #652192]

Mon, 06 June 2016 13:53

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This question bears no real connection with Oracle database.
Please find a more appropriate forum.
The topic is locked. /forum/fa/448/0/

If I'm wrong, please, PM me (or report this message to a moderator, explain why you think it should be unlocked and it might be done).

Report message to a moderator

Previous Topic:	audit_sys_operations
Next Topic:	Software for oracle 11.2.0.4 enterprise edition 32 bit on solaris sparc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 22 14:19:36 CDT 2025