write a script to edit text filedelete a column and add a colon and edit data

$10-25 USD

Completed

Posted

over 8 years ago

$10-25 USD

Paid on delivery

I have a .csv file with around 1500 lines. The format of each line is as following: XXXXXXXXXXXXXXXX,0/00,TEXT for example: 2222222222222222,1/2016,text 3333333333333333,12/2016,555 1111111111111111,3/2016,000 According to the example above, I need the following: Delete the last section (3rd part): text or number Edit the date. for months January to September add zero. so if it's 1 make it 01/2016 Note==> I can not send the file because it contains sensitive information.

Embedded Software

Microsoft Office

Software Architecture

Software Development

Windows Desktop

Project ID: 8906432

About the project

12 proposals

Remote project

Active 9 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

Awarded to:

@AHTOAH

Hello, I'm a vb.net programmer with great experience and I just made a tiny application for converting csv files as per your instructions. Let me know if you are interested and I can provide it and can further customize it. Regards, Tony

$21 USD in 0 day

5.0

(17 reviews)

3.8

12 freelancers are bidding on average $21 USD for this job

@macroPOL

Hello, I am Excel and VBA expert. I can write a macro to do the project. will you send a file the person who will be doing the project?

$22 USD in 1 day

5.0

(7 reviews)

4.0

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i can do this for you. Basically i would create you an excel macro that would loop through each line remove third item and add leading zero for months 1-9. This is really simple and i could probably do it in less then 1h. If you are interested just pm me. Thanks, Milan

$15 USD in 0 day

5.0

(3 reviews)

2.4

@aahhbegins

HI . I HAVE A GOOD EXPERIENCE OF DEVELOPMENT ..........................................................................

$20 USD in 1 day

0.0

(0 reviews)

0.0

@logicalsoft

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@Mamidi333

Hi Mate : I have strong working knowledge on M S Office tools and familiar with the nature of work. I believe i can support 100% and fulfill your requirement. Thanks. Cheers !!!

$21 USD in 1 day