can no emails formattad

[Dj.Michael-Beil. de - OMT24 Corp.]

Hi, I wanted to ask if someone knows how I can put an SQL file and that contain emails table in quotation marks (')

Example: (is not yet formatted)
(3000.1, info(ät)online-media-team.domain , 0),

• I want to put the emails all in (') quotes, but I don’t know how to do this with Notepad ++ PS: There are about 300 emails.
  can someone help me

[Coises]

@Dj-Michael-Beil-de-OMT24-Corp
I think you mean you have lines like this:

(3000.1, info@online-media-team.domain , 0),

and you want lines like this:

(3000.1, 'info@online-media-team.domain' , 0),

If that’s it, select Search | Replace… from the menu, then fill in:

Find what : \b([^\s,]+@[^\s,]+)\b
Replace with : '$1'
Search Mode : Regular expression

and click the Replace All button.

Note: Precisely validating an email address, to accept all properly-formed email addresses and only properly-formed email addresses, is trickier than one might think. In context, the expression above will probably work; but check the results to be sure nothing unexpected happened. The expression can be refined to be more precise, if it fails, depending on just what is going wrong.

[guy038]

Hello, @Dj.Michael-Beil.-de-OMT24-Corp, @coises and All,

@Coises, an alternative solution could simply be :

SEARCH [^\s,]+@[\^s,]+

REPLACE '$0'

OR

SEARCH (?!,)\S+@(?!,)\S+

REPLACE '$0'

Best Regards,

guy038

[mkupper]

@guy038 I think your first search expression was supposed to be [^\s,]+@[^\s,]+ which also has a nice symmetry.

[guy038]

Hello, @dj.michael-beil.-de-omt24-corp, @coises, @mkupper and All,

Yes,… Indeed, just a typo :-((

So, regarding my first regex search expression, the right syntax is the @mkupper’s one !

BR

guy038