Login or Register to Ask a Question and Join Our Community


Programming

Get correct mail id

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming Get correct mail id
# 1  
Old 10-03-2016
Get correct mail id
Hi Team,

I have below data , could you please help to get correct mail id in oracle only.

Code:
bhatt,rabi rabi.bhatt@n.com, test, mishra test.mishra@n.com, skype, amit skype.amit@n.com,

output like :
Code:
rabi.bhatt@n.com 
test.mishra@n.com
skype.amit@n.com

Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!
Last edited by RudiC; 10-03-2016 at 06:31 AM.. Reason: Added CODE tags.
# 2  
Old 10-03-2016
Hello Jewel,

Kindly use code tags for commands/codes/Inputs which you are using into your posts as per forum rules. Could you please try following and let us know if this helps you.
Code:
awk '{match($0,/.*@.*.com/);if(substr($0,RSTART,RLENGTH)){print substr($0,RSTART,RLENGTH)}}' RS=" "   Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Jewel
# 3  
Old 10-03-2016
i need in oracle
thanks, but I need this oracle
# 4  
Old 10-03-2016
Hello Jewel,

Could you please elaborate your requirement more here, seems you had edited your 1st post like you needed it in Oracle. Could you please let us know if this is a SQL query which you are doing for a field and there you need to do a check?

Thanks,
R. Singh
# 5  
Old 10-03-2016
Need SQL for below for correct mail id
need SQL for below


I ve below data , could you please help to get correct mail id in oracle only.

Code:
bhatt,rabi rabi.bhatt@n.com, test, mishra test.mishra@n.com, skype, amit skype.amit@n.com,

output like :
Code:
rabi.bhatt@n.com 
test.mishra@n.com
skype.amit@n.com


Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!
Last edited by RudiC; 10-03-2016 at 06:32 AM.. Reason: Added CODE tags.
# 6  
Old 10-03-2016
Any attempts from your side?

Where do your data come from? How did you generate them? Post the DB data structures.
# 7  
Old 10-03-2016
Moderator's Comments:
Mod Comment Due to numerous CODE tag violations, Jewel is in read-only mode for a few days.

Future failures to use CODE tags appropriately may lead to Jewel being permanently banned from this site.
These 2 Users Gave Thanks to Don Cragun For This Post:
jim mcnamara rbatte1
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Client was not authenticated to send anonymous mail during MAIL FROM (in reply to MAIL FROM comm

I am having trouble getting mail to work on a red hat server. At first I was getting this message. Diagnostic-Code: X-Postfix; delivery temporarily suspended: connect to :25: Connection refused Then added the port to my firewall. Then I temporarily turned off selinux. I then copied this file... (1 Reply)
Discussion started by: cokedude
1 Replies

2. UNIX for Advanced & Expert Users

Mail -s help ,change the sender to correct one

Hi expert I use mail -s "hello" bruce@sohu.com <kernel-img.conf send mail, it display the sender is lyang001@lyang001-OptiPlex-9010.corp.ad..com How can I change the sender to yanglei.fage@gmail.com to default ? (1 Reply)
Discussion started by: yanglei_fage
1 Replies

3. Shell Programming and Scripting

perl script to check the mail ids in the correct format or not

Hi Folks, I have few mailids in a text file and need to check whether the mailid is in correct format or not. If just to check whether the string is a mailid or not there is a perl module Email::Valid to do the business or we can implement our own logic. But the mail_ids I am having is... (4 Replies)
Discussion started by: giridhar276
4 Replies

4. UNIX for Advanced & Expert Users

need to configure mail setting to send mail to outlook mail server

i have sun machines having solaris 9 & 10 OS . Now i need to send mail from the machines to my outlook account . I have the ip adress of OUTLOOK mail server. Now what are the setting i need to do in solaris machines so that i can use mailx or sendmail. actually i am trying to automate the high... (2 Replies)
Discussion started by: amitranjansahu
2 Replies

5. UNIX for Dummies Questions & Answers

How to send html file in a mail not as an attachment but it should display in the mail in table for

Hi The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment . cat Employee.sql SET VERIFY OFF SET PAGESIZE 200 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON - HEAD... (0 Replies)
Discussion started by: mani_isha
0 Replies

6. Shell Programming and Scripting

how to get the correct alignment in a textfile to a mail using shell script?

Hi All, Can any one solve this prob. Im sending a textfile content as a mail body while sending a mail using shell script. But, that textfile content is a unic command output. So, in mail, im not getting the correct alignment as in textfile. What may be the reason behind this. Can... (1 Reply)
Discussion started by: suman_dba1
1 Replies

7. Solaris

how to forward mail in /var/mail/username to external mail

Dear All, Now I use solaris 10 and I try to forward mail from /var/mail/username to their external mail so what should I do? thank u in advance (2 Replies)
Discussion started by: unitipon
2 Replies

8. Shell Programming and Scripting

pick correct message and mail.

Hi, I have the following small script. How can I just print out the string with missing message and send to hotmail.com? Also, can i set the message a bit more beautiful such as "Dear All, the following list is missing in our system"? #!/bin/sh MSG=/log cat list11.txt | awk ' BEGIN { flag... (2 Replies)
Discussion started by: happyv
2 Replies

9. UNIX for Dummies Questions & Answers

mail problem (NOT Mail or Mail.app)

When I try to use the CLI mail, I get the following error. What's wrong? Welcome to Darwin! % mail root Subject: test test . EOT % /etc/mail/sendmail.cf: line 81: fileclass: cannot open /etc/mail/local-host-names: Group writable directory Do I just need to change the... (1 Reply)
Discussion started by: chenly
1 Replies
Login or Register to Ask a Question