Data matching & appending in Excel or SQL

已完成 已发布的 Oct 28, 2013 货到付款
已完成 货到付款

Small project- looking for bids of $10

Need someone to setup queries so a master list column is referred to and based on provided keywords (most with wild card front and back) append associated flaggings.

Notes:

• % represents wild card. For example, sm%th finds "smith" and "smyth". Also %east finds "Northeast" and "Southeast"

• where % does not exist, there is no wild card

• space sensitive (Very Important)

• not case sensitive

• where there is more than one 'Job Folders' or 'Job Level' separate with ; in the same cell.

• conditions include where a keyword exists or where a keyword does not exist -append a code.

See attached for production file. Let me know if you have any questions.

数据库管理 Excel MySQL SQL

项目ID: #5069879

关于项目

6个方案 远程项目 活跃的Oct 29, 2013

授予:

ramyrafik

Hello I'm an excel formulas expert. I can help u with this very easily. I just want to know what u mean by "conditions include where a keyword exists or where a keyword does not exist -append a code. "

$10 AUD 在1天内
(4条评论)
3.1

有6名威客正在参与此工作的竞标,均价$22/小时

firmuscode

Hi, I have wide experience in SQL and Excel. I have had a look into your excel, Please message me your exact needs. I would get the task done to you today under one hour or so.

$15AUD 在1天里
(4条评论)
3.8
netquart

A proposal has not yet been provided

$25AUD 在1天里
(9条评论)
3.6
mastermontilla

Hi,. it seems your requirements to your project was fit to my qualifications. I can re design your excel template that would help you a lot more presentable.. Feel free to see my portfolio. And i will send you later a 更多

$25 AUD 在3天内
(0条评论)
0.0
elsayedmb

A proposal has not yet been provided

$24AUD 在1天里
(0条评论)
0.0