Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Regular expressions: regex (Read 2007 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Regular expressions: regex
30.05.15 at 08:55:45
 
Regular expressions: regex
 
Some examples of regular expressions for search and replace actions:
 
Task: Move Op. 12 to the front of the string:
Original text: First Op. 12 Last
New text:      Op.12 - First - Last
regex: (.*) Op. ([0-9]*)(.*)
replace: Op.\2 - \1 -\3
 
Task: Move Op. 34 to the fron of the string and remove the leading numbers 12:
Original text: 12 - First Op. 34 - Last
New text:      Op.34 - First - Last
regex: ([0-9]*)(.*) Op. ([0-9]*)(.*)
replace: Op.\3\2\4
Back to top
 
« Last Edit: 30.05.15 at 09:04:09 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1