|
i have table named "path" with a single column named "path file name" and it contains something like this below: 1. U:01.03.141878Box1819P3FarihaTanzir(Moniruzzaman)0103141(756).jpg 2.U:01.03.141876Box1807P3Arif(Mahfuz)151213Picture 96609.jpg 3.U:01.03.141130Box1781P3RakhiSwpna(Farah)0103141 (1486).jpg 4.U:01.03.141952Box1810P1Sufia(Jakia)010314Picture 25304.jpg i want to get the names within the first braces() like: 1.Moniruzzaman 2.Mahfuz 3.Farah 4.Jakia i have used combination of patindex(),charindex() and substring function with left and right but could not get the desired result ,plz help. |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 02 Mar '14, 14:03
question was seen: 1,601 times
last updated: 02 Mar '14, 16:17
Your question does not have anything to do with SQL Anywhere, so this is not the right place to ask it.