已完成

Regex expert familiar with google spreadsheets

Hi,

I have a list of rows containing names and email addresses.

I need to get rid of names and keep email addresses only.

I want to do it in spreadsheets with bulk replacing everything not containing @ in it with an empty field (nothing).

Example below (please note that Freelancer does not allow me to put email address into project description so I replaced @ with *):

Peter Jackson

john*[login to view URL]

John Wayne

Peter Andres

valeria232*[login to view URL]

michael*[login to view URL]

I would enter regular expression provided by you into the replace field and as a result my text would look like this (desired state with emails only, as all string without @ in it were replace by empty field):

john*[login to view URL]

valeria232*[login to view URL]

michael*[login to view URL]

As this is very simple task, budget is 10 USD

Thanks

技能: Excel, 数据处理, 正则表达式

查看更多: css expert familiar theme, email addresses google spreadsheets google contact list, seo expert work google, google maps expert contact google maps, count entry google spreadsheets, google spreadsheets api php, google spreadsheets timetime, mls checker google spreadsheets, saving form php google spreadsheets api, google spreadsheets imacros, magento seo expert page google, google spreadsheets php api add row, google spreadsheets seo, expert advertising google adwords needed, perl net google spreadsheets, expert advice google adsense, google spreadsheets perl, mashup google spreadsheets calendar, google spreadsheets help, google spreadsheets connects ecwid store

关于此雇主:
( 86个评论 ) Dublin, Ireland

项目ID: #25489188

授予:

ksriniravi

Greetings! Actually the more easier option is to use filters as opposed to Regex. Set up a filter with Filter by condition option. Choose Text does not contain option and enter @. All values without text @ would be 更多

$10 USD 在1天内
(202条评论)
6.8

140 威客就此工作平均出价 $16

cgullapalli

HI, I am good at Google sheet formulas. I can pull the information you are looking for using formulas. Looking forward to work on the project. The formula is flexible for any number or rows in google sheet. I will wr 更多

$30USD 在1天里
(920条评论)
8.1
sergiuloghin

Hello! I can resolve this now with a VBA script. Can you award me? You will not be dissapointed, I have a big 30% rehire rate. Thank you!

$15USD 在1天里
(306条评论)
7.8
mohsinalizafar

Hi sir i can help you in this please message me so that we can start i am waiting for response thanks

$20 USD 在7天内
(32条评论)
5.3
belalihabibullah

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task.I am a quick, reliable and efficient worke 更多

$10USD 在1天里
(41条评论)
5.3
elbruninh

⭐⭐⭐Hi, i can do it, can you send me the data? i have 18+ years of experience with Regular Expressions let me know if you are interested [login to view URL]

$10USD 在1天里
(20条评论)
4.4
ARTICLEYOUWANT

I am ready to do this task at USD 10 with quick turnaround time. I am ready to do this task at USD 10 with quick turnaround time.

$10 USD 在2天内
(6条评论)
4.1
mdrakibuddn

$10 I agree Hi There! https://docs.google.com/spreadsheets/d/1BNsw-KqW3GU6smzNgA-6q2Fo5VIM71OyvZRQgq-6pdU/edit#gid=0 I am ready to start the job for you. Do you need quick samples from me before hiring? Please let 更多

$10USD 在1天里
(5条评论)
3.3
ahmedala3sar1111

Hi sir , I am Ahmed ,I wish you a good day . I have done many projects on MS office programs (word, excel, PowerPoint, Prezi, pdf, ...etc.) for five years. I have done similar project before you can check it in my po 更多

$10USD 在1天里
(4条评论)
3.0
sathiswarrior

Hi, I understand your proposal and I'll complete the task within one hour. Please share the file ready to start. Thanskwtih regards Sathiya N

$10USD 在1天里
(5条评论)
2.4
imtyzooel71n

Greetings, I can do this project with $10 I can do this project with $10 I can do this project with $10 I can do this project with $10 If you think me best candidate for the project then move on for next process. T 更多

$10USD 在1天里
(7条评论)
2.5
mohanasundarik24

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I understand t 更多

$10USD 在1天里
(5条评论)
1.9
zubairmbafinance

Hi sir, I am Zubair I have done MBA in finance I read your project and I have experience of more than 4 years I have worked for MTBC an American company as billing executive with the experience and paid tools I have I 更多

$20 USD 在2天内
(3条评论)
1.8
Pooja19jayswal

Hello, Sir I Am Pooja Jaiswal. and am interested to do your help . please share with me your data . thanks&Regards, Pooja

$20 USD 在7天内
(0条评论)
0.0
akkijais86

Dear sir/ma'am I would like to tell you I am expert in excel and data entry work . Plz allow me to do work on this project . Thanks Relevant Skills and Experience I am fluent in Microsoft Excel and data entry .

$25USD 在1天里
(0条评论)
0.0
wwwmaklemza

I am very fast in typing and i can finish your project very fast and that can save you a lot of time

$20 USD 在7天内
(0条评论)
0.0
RAMESHB200

HERE IS YOUR ANSWER: 1. With the google-sheet open, use the FIND and REPLACE option (CONTROL H in windows). 2. Use Regex (?:.*?(\w[^@\s]*@[^@\s]{2,}).*?|.+) under the FIND field 3. use expression $1 in the REPLACE fiel 更多

$10USD 在1天里
(0条评论)
0.0
joysarkerprince

dear sir plz give me this work i ill best to try ghis work and i ill do this work just time and i think your mony will be safe so plz give me this work i also a frofosonal worker in this project so plz u think me that 更多

$25USD 在1天里
(0条评论)
0.0
chachu786

Since I have been using excel for the last 17 years and confident to do this work within the frame time.

$20 USD 在7天内
(0条评论)
0.0
shaliniojha30

hello I'm shalini . I want to do your work more accurately and on time ... 100 ℅ grantee for good work ....tq

$20USD 在1天里
(0条评论)
0.0
Duanitika

I can make sheet with desired as many as large dataset is. I am good at advance excel as well as formulas if needed. Please let me do this project.

$25USD 在1天里
(0条评论)
0.0