Auto cut csv list after certain symbol.
€2-6 EUR / hora
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
Nº del proyecto: #6483508
Sobre el proyecto
Adjudicado a:
Hi sir, I will write function in your excel that will automatically remove anything after the & sign. 5 mins work. thanks
8 freelancers están ofertando un promedio de €4 / hora por este trabajo
Hi, i can finish in one hour lets begin payment after job completion waiting your answer Regards
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
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,
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