Auto cut csv list after certain symbol.

Completado Publicado Sep 20, 2014 Pagado a la entrega
Completado

Hi ALl,

I am looking for a solutions for some simple work i now do manually.

I have a link like this: [url removed, login to view]

But i need only the link url untill the "& sign". All other numbers and letters after the & SIGN must be deleted.

I have a big list of these kind of url's and looking for a wat to cut them all in once.

Mabey there is a way to cut it by using a code in Excel. csv.

Any option wil be ok with me.

Kind regards

PHP Arquitectura de software

Nº del proyecto: #6483508

Sobre el proyecto

8 propuestas Proyecto remoto Activo Sep 20, 2014

Adjudicado a:

rohitagarberg

Hi sir, I will write function in your excel that will automatically remove anything after the & sign. 5 mins work. thanks

€2 EUR / hora
(74 comentarios)
4.9

8 freelancers están ofertando un promedio de €4 / hora por este trabajo

ajitsg

A proposal has not yet been provided

€2 EUR / hora
(36 comentarios)
4.7
ahmedsobherfan

Hi, i can finish in one hour lets begin payment after job completion waiting your answer Regards

€2 EUR / hora
(40 comentarios)
4.6
cplaiasu

Hello, I have a very simple and effective solution for you. You just need a simple free software, Libre Office or Open Office. There is a nice command, text to columns, that will transform all rows from 1 column i Más

€5 EUR / hora
(12 comentarios)
3.6
gcStudioOrg

Hello, i don't know a way to do it in excel but i can make u a nice PHP script where you provide the csv file & it search and truncate each url & save afterwards. Please message me if you would like for further discuss Más

€4 EUR / hora
(7 comentarios)
3.3
Sshram

I would make your url cut to the sign and use by you as needed. will devise a way to create a new file with updated url.. SKYPE-sshrammanven for sshram marketing thanks,

€4 EUR / hora
(1 comentario)
0.0
amrboghdadysl

Hello, Here's the formula you need in excel, assuming the link is in cell A1: =LEFT(A1,FIND("&",A1)-1) This formula could very easily be applied to a whole list in excel. Wouldn't take a minute. If you find thi Más

€2 EUR / hora
(0 comentarios)
0.0