My objective is to provide the various use cases & necessary information to everyone to be master in some of the technology I’ve worked for few years. So, you can design, develop & write better programs & get a flavor of this powerful feature & exploit them in all the positive aspects & apply them properly.
Also, currently, I’m working on Data Science is driven solutions along with cloud computing. Hence, I’ll be sharing many posts on Python & other relevant data science-based tools.
I have more than 15 years of Software Development experience & would like to exchange my knowledge with others. 😀
Besides that, I’m a passionate photographer & try to capture them in my frame whenever possible. Here, I’m sharing some of my pictures, which got many awards across the world. I have my photography site, which you can get from this link. 🙂
If you wish, you can visit my photography site by clicking the above link & let me know your feedback on that one as well. 😀
Tags: #python #cloud #azure #aws #gcp #microservice #api #gui #web #json #multithread #multiprocess #ibm #watson #twitter #datascience #sql #pandas #dataframe #analytics #realtime #dashboard #streaming #data #amadeus #railway #prediction #covid19 #analysis #regression #linear #neural #network #xml #xsl #xls #csv #text #file #class #ably #pubsub #ai #encryption #masking #teradata #tableau #powerbi #dashboard #numpy #plotly #matplotlib #scikitlearn #library #json2df #df2json #loganalytics #cosmosdb #nosql #oracle #mysql #circuitbreaker #deadletterqueue #redshift #matilion #adf #databricks #dataflow #eventhub #aks #alteryx #select #partionby #over #regexp #ui #qt5 #designer #briefcase #toga #ios #apple #android #microsoft #mobile #app #otn #vm #virtual #env #pytorch #pypi #github
Hi ,
I am have use case where I need to extract a particular code from a varying column which has the URL data.I am using position and sub string but wanted to see if Regular expression would solve the problem.
Definitely you can do that provided you are well aware of the end pattern of your string.
Can you provide some sample data & your expected output?
Hi-
I am trying to extract characters in between “(” and “)” in a string field. To elaborate if I have a field with the value-
“This is easy and I (John Smith) can help you achieve that.”
When I run the query the output should be “John Smith”
I used REGEXP_SUBSTR(column_name, ‘[?<(].*?[?)]') and I got result like "(John Smith)".
Can you please let me know what needs to be modified to get the desired result?
Thanks
Sri