tag:blogger.com,1999:blog-8502142627599800928.post4048164832223556527..comments2024-03-06T02:14:43.791-08:00Comments on Best Way To Understand BI and Data Visualization And How Everything Works Here: How to locate the reoccurring character in the stringBojiehttp://www.blogger.com/profile/13163354520521690612noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8502142627599800928.post-40973614468147639582020-11-26T17:55:09.258-08:002020-11-26T17:55:09.258-08:00Hi,
I am looking at this post in 2020, but its aw...Hi,<br /><br />I am looking at this post in 2020, but its awesome that way you explained it.<br /><br />Can I ask how would you do it if we were to extract the 2nd substring (e.g. HSPA only from your 10083_HSPA_CD_10005)<br /><br />I am unable to get a proper formula that will do that in OBIEE without causing performance issues.RWhttps://www.blogger.com/profile/02816240115051989200noreply@blogger.comtag:blogger.com,1999:blog-8502142627599800928.post-77534592313042187382018-10-10T21:03:02.089-07:002018-10-10T21:03:02.089-07:00Great info. How would you pick up the string valu...Great info. How would you pick up the string values before or after the special character? <br /><br />i.e. <br /><br />10083_HSPA_CD_10005<br /><br />Result:<br /><br />Column 1: 10083<br />Column 2: HSPA<br />Column 3: CD<br />Column 4: 10005<br /><br />Appreciate your assistance.Unknownhttps://www.blogger.com/profile/03838606582568129619noreply@blogger.com