Forum Discussion
Extract Address from Cell Text
Background: I'm working with address data that uses the quadrant system (ends with NW, NE, SW, or SE). There are only very few instances where it ends with N or S. I have a column of data that...
Thanks so much for making the adjustments! Next time I will know to provide more dummy data to help illustrate my cases. I'm still developing my Power BI skills so I'm hoping you can offer some more guidance to a rookie when using this formula.
The Excel file isn't actually the source data and allowed me an easier way to see the data as of right now.
Source: Oracle
Navigation: SYNERGY{[Name="WORK_ORDER"]}
Column (with address): [WORK_DESC]
I am not strong at querying and am mistyping something that is leading to errors:
Source = Oracle.Database("Oracle",SYNERGY{[Name="WORK_ORDER"]}[WORK_DESC]),
Any further assistance is greatly appreciated, and if you need more information, please let me know.
The Excel file isn't actually the source data and allowed me an easier way to see the data as of right now.
Source: Oracle
Navigation: SYNERGY{[Name="WORK_ORDER"]}
Column (with address): [WORK_DESC]
I am not strong at querying and am mistyping something that is leading to errors:
Source = Oracle.Database("Oracle",SYNERGY{[Name="WORK_ORDER"]}[WORK_DESC]),
Any further assistance is greatly appreciated, and if you need more information, please let me know.
https://www.oracletutorial.com/oracle-string-functions/oracle-regexp_like/
oracle support regular expression.
You can try it
oracle support regular expression.
You can try it
Could you suggest regex pattern for such case?
OK
Because I have no ORACLE environment.
I use sqlite for example.
select *,regexp2('^.*\b(NW|NE|SW|SE|N|S|E|W|Ave)\b',f01)
f02 from Sheet1;
Oracle extract:
https://www.oracletutorial.com/oracle-string-functions/oracle-regexp_substr/
