Sponsored Content
Full Discussion: Get correct mail id
Top Forums Programming Get correct mail id Post 302982709 by Jewel on Monday 3rd of October 2016 03:30:00 AM
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 :

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.
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
STG-IMPORT(1)							   StGit Manual 						     STG-IMPORT(1)

NAME
stg-import - Import a GNU diff file as a new patch SYNOPSIS
stg import [options] [<file>|<url>] DESCRIPTION
Create a new patch and apply the given GNU diff file (or the standard input). By default, the file name is used as the patch name but this can be overridden with the --name option. The patch can either be a normal file with the description at the top or it can have standard mail format, the Subject, From and Date headers being used for generating the patch information. The command can also read series and mbox files. If a patch does not apply cleanly, the failed diff is written to the .stgit-failed.patch file and an empty StGIT patch is added to the stack. The patch description has to be separated from the data with a --- line. OPTIONS
-m, --mail Import the patch from a standard e-mail file. -M, --mbox Import a series of patches from an mbox file. -s, --series Import a series of patches from a series file or a tar archive. -u, --url Import a patch from a URL. -n NAME, --name NAME Use NAME as the patch name. -p N, --strip N Remove N leading slashes from diff paths (default 1). -t, --stripname Strip numbering and extension from patch name. -i, --ignore Ignore the applied patches in the series. --replace Replace the unapplied patches in the series. -b BASE, --base BASE Use BASE instead of HEAD for file importing. --reject Leave the rejected hunks in corresponding *.rej files. -e, --edit Invoke an editor for the patch description. -d, --showdiff Show the patch content in the editor buffer. -a "NAME <EMAIL>", --author "NAME <EMAIL>" Use "NAME <EMAIL>" as the author details. --authname AUTHNAME Use AUTHNAME as the author name. --authemail AUTHEMAIL Use AUTHEMAIL as the author e-mail. --authdate AUTHDATE Use AUTHDATE as the author date. --sign Add a "Signed-off-by:" to the end of the patch. --ack Add an "Acked-by:" line to the end of the patch. STGIT
Part of the StGit suite - see linkman:stg[1] StGit 03/13/2012 STG-IMPORT(1)
All times are GMT -4. The time now is 02:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy