Convert text to excel

$250-750 USD

Closed

Posted

about 11 years ago

$250-750 USD

Paid on delivery

I need someone to write a script that converts a text file into rows of excel. I need you to take each line of text and take the words separated by the "|" in the line and put them into different columns. Here is an example of one of the lines. 0HONG KWANHI|801 N 2ND ST K82|BLYTHEVILLE |AR|72315-2021|ENTERGY ARKANSAS INC|Utility Deposits|10/28/2005|$50.85|10670116 If you are interested in this job, send me a sample of 100 rows so that I can see that you've done it correctly, and also that you're not doing it by hand. Thanks

Data Entry

Excel

Project ID: 4371517

About the project

25 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

25 freelancers are bidding on average $280 USD for this job

@Icebear951

I have to do tasks like this on a regular basis, so I can get this done for you quickly. If you have 100 examples I can create the rows seperated into columns for you today.

$250 USD in 1 day

5.0

(2 reviews)

2.4

@srdas2012

Hi,Please check PMB

$250 USD in 7 days

5.0

(2 reviews)

2.1

@iainwatson

Hi there, I recognize the format of the text file you're entering, and it isn't necessary to use a script at all - Excel has functionality built-in that can read this kind of file and automatically convert it to an Excel format. See my private message for more details.

$250 USD in 1 day

5.0

(1 review)

1.8

@paolocarnelli

For informations please see the private message

$250 USD in 1 day

5.0

(1 review)

1.0

@Locust

VBA and text parsing expert here, consider it done. Please provide 100 different lines of text to test my written macro. Thanks.

$250 USD in 0 day

0.0

(0 reviews)

0.0

@Pinky0075

I need more clarifications before starting it. Please see PM

$500 USD in 3 days

0.0

(0 reviews)

0.0

@FOliverosCode

Please check PM Regards

$250 USD in 1 day

0.0

(0 reviews)

0.0

@poulnais

Hello as software engineer, I'm able to write a script to convert your text in excel file. Please let's have a look to my PM. Best regards Olivier POULNAIS

$250 USD in 2 days

0.0

(0 reviews)

0.0

@nmlemus

I have a solution to your problem runing in Java, take a look at my portfolio. I cant attach anything here. I only need 100 USD for the solution. Regards Noel

$250 USD in 0 day

0.0

(0 reviews)

0.0

@nicu66pr

Let's start!

$250 USD in 2 days

0.0

(0 reviews)

0.0

@sudewa

Hi, You dont need a tool. Copy to excel and use text to columns option. Its quick. If you want I can do a script for you. Thanks, Sudewa

$250 USD in 1 day

0.0

(0 reviews)

0.0

@orrjosh

I have this script done already. I will provide you with a professionally engineered script that meets your exact requirements

$250 USD in 1 day

0.0

(0 reviews)

0.0

@DataEntryPro48

<<< See Me, Judge Me >>> I have experience to work MS EXCEL "PRACTICALLY". I had been an ACCOUNTANT in KDS Steel Ind. I have VAST knowledge over # MS WORD, # MS EXCEL, # MS POWERPOINT, # ADOBE PHOTOSHOP, # ADOBE ILLUSTRATOR, # TALLY (Accounting Software)

$280 USD in 6 days

0.0

(0 reviews)

0.0

@CherryInnovators

We can do this job > we are ready

$500 USD in 3 days

0.0

(0 reviews)

0.0

@maniteja009

i can do this...

$250 USD in 2 days

0.0

(0 reviews)

0.0

@fadyfady022

I can do that for you in 1 day

$330 USD in 1 day

0.0

(0 reviews)

0.0

@MilicaS

Hi! With Excel built in function I can do this job easily and very accurate! Do not hesitate to contact me!

$250 USD in 1 day

0.0

(0 reviews)

0.0

@vmaxveera

Hi, please PM me with sample... Thanks

$275 USD in 3 days

0.0

(0 reviews)

0.0

@jamesls59

You can do this task simply using the "Text to Columns" command found in the Data tab of Excel. You merely highlight the cells in one column that you wish to process (insure there are blank columns to the right of the highlighted cells), then click the Text to Columns icon. You will be prompted to specify fixed width or delimited (in your case delimited) and when you click Next, you will specify the delimiter (|) in the Other box. Click finish and the text will be separated into separate columns. Also, the delimiter will be omitted.

$250 USD in 1 day