Terminé

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

Compétences : Excel, Traitement de Données, Exploitation de Données

en voir plus : 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

Concernant l'employeur :
( 6 commentaires ) Sleaford, United Kingdom

Nº du projet : #21888627

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(270 Commentaires)
7.0

104 freelance font une offre moyenne de £89 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(722 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(927 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(329 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(323 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(237 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(128 Commentaires)
7.3
asifdwan

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(245 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(84 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(252 Commentaires)
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] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(121 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(183 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(143 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(258 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(58 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(112 Commentaires)
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)

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(161 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(78 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(45 Commentaires)
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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(117 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(52 Commentaires)
5.8