Data Extraction [message #684465] |
Fri, 11 June 2021 09:30 |
|
ssharmila
Messages: 1 Registered: April 2021
|
Junior Member |
|
|
Hi Team,
I am having a LOG_Comments column VARCHAR2(4000 BYTE), it contains mail ids, some random text with mail ids and numbers too
Am trying to query the rows which is having the email id and numbers
while using REG_EXP LIKE am getting the columns having only mail ids , but i need to get some random text with mail ids also
eg : I can able to retrieve 'xyz@abc.com' but not 'Replacement -need abc@ghncom,xyz@ghn.com'
please suggest your ideas
|
|
|
|
|
Re: Data Extraction [message #688114 is a reply to message #688110] |
Fri, 25 August 2023 00:47 |
|
mathguy
Messages: 108 Registered: January 2023
|
Senior Member |
|
|
Aarondedja wrote on Wed, 23 August 2023 12:25I I know this response might come a bit late, but for others in the same boat, here's an idea. Dealing with data extraction quirks can be a puzzle! When it comes to retrieving both email IDs and the random text around them, it's a bit tricky. You could try diving into product data cleansing techniques.
Brilliant! How could we miss such a remarkable answer?
I stand in admiration of your great first contribution to the forum. I hope we will get many more from you in the future!
|
|
|