CSV formula/macros

I have several excel spreadsheets that have different column formats. However they all have an email column with email addresses. Next to the email column there is an email format column.

I would like a script that would read from the email column and then add in the email format column a string of characters that will explain how the email is construed.

For example if the email says [login to view URL]@[login to view URL] then the email format column will show _F_._L_@_D_

_F_ being FIRST NAME

_L_ being LAST NAME

_D_ being domain

some email addresses have other formats. For example it could be bmarkey@xyz so the email format will be _FF__L_@_D_

_FF_ being first letter of the first name

_FL_ first letter of the last name

sometimes it can also be just _F_@_D_ or _L_@_D_

Also the separators between names can be a . (dot) but also an _ (underscore) like in bob_markey@[login to view URL] which becomes _F___L_@_D_

I would like the end result to be a formula or anything that I can simply plug into all my different CSV sheets.

MAX BID: $10

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic

Lihat lagi: design of macros and programming in vba with excel 2016 ebay, csv formula java, java csv formula, csv injection hackerone, formula injection vulnerability, csv injection calc, formula injection owasp, csv injection vulnerability, csv injection owasp, csv injection cheat sheet, csv injection tutorial, data entry, data processing, software architecture, excel, visual basic, visual basic for apps, microsoft excel, bulk domain registration csv, csv bulk domain registration

Tentang Majikan:
( 456 ulasan ) Richmond Hill, Canada

ID Projek: #15681338

Dianugerahkan kepada:


Hello, I can do this for you, pretty quick. I am okay with your price of $10. Relevant Skills and Experience I am proficient with Excel and VBA and can finish this 100% accurate. Proposed Milestones $30 USD Lagi

$15 USD dalam sehari
(144 Ulasan)

13 pekerja bebas membida secara purata $16 untuk pekerjaan ini


Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with exce Lagi

$40 USD dalam sehari
(306 Ulasan)

Hi there. I am Paris and I can develop this simple macro for you. Relevant Skills and Experience I've developed similar projects in the past. Proposed Milestones $10 USD - Deliver the final macro

$10 USD dalam 0 hari
(170 Ulasan)

Your task is clear to me and I am ready to execute the project for 10 USD for 1 day. Relevant Skills and Experience This is a screenshot of one of my works. [login to view URL] Lagi

$10 USD dalam sehari
(61 Ulasan)

Hi, I can do this work. Individual and hard working person done your work accurately. Waiting your response. Relevant Skills and Experience Data Entry, Data Processing, Excel, Software Architecture, Visual Basic P Lagi

$15 USD dalam sehari
(19 Ulasan)

I work with Excel formulae daily. I'll be able to deliver a crisp formula that works for every type of email address in your csv files! I hope to hear from you

$15 USD dalam sehari
(4 Ulasan)

Hello . I can help you to decide your task Relevant Skills and Experience Excel, VBA Proposed Milestones $10 USD - data formatting

$10 USD dalam sehari
(1 Ulasan)

I am good working

$15 USD dalam sehari
(0 Ulasan)

I understand your requirement, I can create a macro to deal with this and a compact algorithm to deal with email scenarios you get. Macro will have alot of flexibility at your end to change if you wish to.

$10 USD dalam 2 hari
(0 Ulasan)

A proposal has not yet been provided

$15 USD dalam 2 hari
(0 Ulasan)

A proposal has not yet been provided

$15 USD dalam sehari
(0 Ulasan)

A proposal has not yet been provided

$20 USD dalam 4 hari
(0 Ulasan)

The completed excel will fill the required coulmn with computed data as per requirement on click of a button located on same sheet. Relevant Skills and Experience Have worked on excel macros extensively and have very Lagi

$15 USD dalam sehari
(0 Ulasan)