Færdiggjort

filter csv file data

Hi,

I have a csv file with 2500 lines from a gmail calendar download and I need the name, job description, price and phone number data separated into separate columns, as well as the address and postcode data. Currently the information is in a similar format to below:

Mr Smith, leather sofa and lounge dining, £25+£15, 01522792267

Andy, whole 3 bed bungalow, £55, 07801692498

Mr Singleton - tile floor in wetroom - 01529 415 563, £99

The format I need is (new column is shown by | ):

Mr Smith | leather sofa and lounge dining | £25+£15 | 01522792267

Andy | whole 3 bed bungalow | £55 | 07801692498

Mr Singleton | tile floor in wetroom | £29 | 01529 415 563

Thanks

Evner: Excel, Databehandling, Datasøgning

Se mere: difference csv csv file data java, perl script insert csv file data mysql, importing csv file data grid, oscommerce csv file data upload, filter csv file via script, full code show csv file data grid, javascript display csv file data, uploading csv file data mysqldatabase, import csv file data grid visualbasic 2008, csv file data insert magento, net load csv file data blank, programatically inserting csv file data quickbooks, update table csv file data asp net, windows service import csv file data, python csv file data, csv file data entry, csv file data grid, i will provide names address phone email etc etc on a pdf file i need the information put in an excel spread sheet under company, Specification 1. The program should read the data that is contained in a comma-separated text file and store the information in

Om arbejdsgiveren:
( 6 bedømmelser ) Sleaford, United Kingdom

Projekt ID: #21888627

Tildelt til:

sujitkar

Hello, there! I have understood that you need the column values segregated into multiple columns as given in the example 1 (current form) to example 2(desired form). I am highly skilled in MS Excel and will be able t Flere

£20 GBP på 1 dag
(270 bedømmelser)
7.0

104 freelancere byder i gennemsnit £89 på dette job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Flere

£100 GBP på 1 dag
(722 bedømmelser)
8.5
jeweljitu

Dear Employer, I will fix it manually 1 by 1 so the job will be done 100% accurately. I will complete the project within 3days coz manually processing. if I use some automatic away then the problem of getting an e Flere

£150 GBP in 3 dage
(927 bedømmelser)
8.5
Innovative116

Hi there. I am a full time spreadsheet formatting expert. Separating 2500 contacts in there respective columns as explained will be done within 24 hours of project awarding. I have decade long experience and have compl Flere

£125 GBP på 1 dag
(329 bedømmelser)
8.3
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Flere

£180 GBP in 3 dage
(323 bedømmelser)
7.9
FINGERRPRINT

Hi there!, We can separate each information in separate column and get the output within 24 hr of project award. We provide full time data entry service since 2009. Most reliable. We would be grateful, if our bid consi Flere

£100 GBP på 1 dag
(237 bedømmelser)
7.7
zekovicm

Hi there, I can write some macros that will separate all the data into separate columns where they belong . Check out my profile and former clients feedback - that'll let you know everything about me. Please feel fr Flere

£155 GBP in 7 dage
(128 bedømmelser)
7.3
asifdwan

Hi, 100% sure I will give you 2500 lines your provided format Please share me. Thanks....................................

£50 GBP på 1 dag
(245 bedømmelser)
7.1
dgled

Hi, I am a financial expert and Excel/VBA/Macro guru with considerable experience working with Excel, especially uploading files, organise and manipulate spreadsheets in a structured database and populate reports from Flere

£135 GBP in 7 dage
(84 bedømmelser)
7.1
BithiXpert

Hello Dear, I am an expert in Data Entry, Data Processing, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will pro Flere

£50 GBP på 1 dag
(252 bedømmelser)
7.1
hatemfreelance4

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Please visit [login to view URL] Flere

£35 GBP på 1 dag
(121 bedømmelser)
6.6
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can semi-automate the process and subsequently manually verify the results. Ple Flere

£25 GBP på 1 dag
(183 bedømmelser)
6.8
hdlong66

Hello, I can split 2,500 cells into respective columns name, job description, price and phone number. Please drop a PM if you’re interested. Best regards, Hoang

£35 GBP på 1 dag
(143 bedømmelser)
6.8
eltamarisa85

I can start now to format 2500 lines into separate columns. I don't have any work for this time, so i can spend all my time. I have completed some data processing project before, feel free to review my profile. Plea Flere

£50 GBP på 1 dag
(258 bedømmelser)
6.9
mahfuz80

Hi, I have read your project description and i have understood about your data mining project. I can do your project quickly and accuracy according to your instructions. So, I am ready to do your project right now. I a Flere

£200 GBP in 3 dage
(58 bedømmelser)
6.4
onlinejob247

Okay. 2500 line I will give you like your format. Quality and time is my commitment. I have huge experience in working with these projects. If you need sample work just send me a message. Waiting for your quick reply Flere

£30 GBP på 1 dag
(112 bedømmelser)
6.4
rajstk

HELLO THERE, I CAN FILTER CSV FILE 2500 DATA ACCURATELY AND PROFESSIONALLY AS WELL AS FASTER. WE CAN DISCUSS MORE DETAILS IN MESSAGE INBOX. BEST REGARDS, MAYARAJ MAHABUB (RAJ)

£50 GBP på 1 dag
(161 bedømmelser)
6.8
TechnoGuruu

Hi, I am a full time freelancer and can work dedicated on this till completion. As per requirements I will filter your CSV data as per description of the project. Please share your Excel sheet. I have expertise in Exc Flere

£99 GBP in 3 dage
(78 bedømmelser)
5.9
uhjk

Hello, if you send me .csv file I can do this format change in 1-2 hours. I will import data to mysql database and change format.

£40 GBP på 1 dag
(45 bedømmelser)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

£100 GBP in 2 dage
(117 bedømmelser)
5.9
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to CSV, Excel, MS Word, Google Sheet, Access, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://ww Flere

£50 GBP på 1 dag
(52 bedømmelser)
5.8