Devam Ediyor

Merge csv files - horizontally

Need a utility to merge multiple delimited (comma or tab) text files in horizontal fashion. Functionality needs to include:

1 - exclusion of columns by position (not used by the exampled files attached)

2 - exclusion of duplicate columns (indicated by the first/header row of all files containing text values being duplicated across columns)

3 - user naming of output file

4 - capable of merging 100 csv files

Using the attached files as example:

The first two (tagged Merge Test) files are merged to the file named Result. In Result, the first 36 columns (A-AJ in Excel) occur only once even though each of the source files contained the same column. In the example, it is always the first 36 columns which are duplicated, in my real situation, other fields are duplicated in random positions but always with a duplicate value in the first row of the file (or header record if you will).

- Utility can run under Windows 7 or OSX 10.6

- can be Excel VB (using Excel 2010 for Windows) module code or add-in

This project is a small part of a larger project requiring monthly processing of text files and importing to a mySQL database, which may include some verification steps on source formatting as it tends to change occasionally. I will consider working on a more comprehensive project with somebody who can deliver on this first step successfully.

Similar functionality can be found in the program here ([url removed, login to view]), which lacks the ability to manage duplicate columns.

Beceriler: C++ Programlama, SQL, Visual Basic

Daha fazlasını görün: merge csv files, merge csv, merge csv horizontal, merging files horizontally, file merging horizontal, merge horizontal csv files, merge multiple csv files, merge csv file horizontally, horizontal merge csv, working positions, source formatting, formatting utility, database positions, horizontally merge csv files, merge excel files horizontally, merging excel files horizontally, merge csv horizontally, merge csv files horizontally, merge csv column, attached files, naming, CSV, aj, excel database visual basic, mysql output html

İşveren Hakkında:
( 1 değerlendirme ) Georgetown, United States

Proje NO: #722952

Seçilen:

Mxdmg

I am intrested in development of this project

0 gün içinde 49$ USD
(2 Değerlendirme)
2.6

33 freelancer bu iş için ortalamada 119$ teklif veriyor

simonchen

Please check p.m.b, thanks.

in 7 gün içinde250$ USD
(37 Değerlendirme)
6.3
srinichal

Nice looking GUI will be delivered as part of the main code

in 3 gün içinde180$ USD
(49 Değerlendirme)
6.1
eperfections

Please see PMB

in 3 gün içinde125$ USD
(84 Değerlendirme)
6.0
svet63

Excel/VBA developer since 1997. Can certainly do. My bid is for Excel based utility. Regards, Svet.

in 3 gün içinde120$ USD
(43 Değerlendirme)
6.0
tejas34

We ready to provide utility in 1 day. If you have no language constrain, we will provide in .Net.

1 gün içinde 140$ USD
(21 Değerlendirme)
5.3
wsh2

Greetings Colorado from Pennsylvania.. {smile} 25+ years Excel programming and Data Transformation expert. Please see PMB. Respectfully, Bill.

in 2 gün içinde175$ USD
(18 Değerlendirme)
5.1
DamithaKD

I can do this :) Programmer for6 years.

in 2 gün içinde50$ USD
(13 Değerlendirme)
4.6
panfreelancer

Please check PM. Thanks.

in 3 gün içinde60$ USD
(10 Değerlendirme)
4.4
mrbrave

Ready to start now...

in 2 gün içinde80$ USD
(17 Değerlendirme)
4.3
gangabass

I can do this job for you. See PM for details.

in 2 gün içinde50$ USD
(25 Değerlendirme)
4.1
mike25

Hi - please see pm for remarks. Thanks, mike

in 3 gün içinde100$ USD
(5 Değerlendirme)
3.8
softwarehandyman

Hello. I have a handle on what needs to be accomplished. Check your PMB for screenshot/download. Thanks.

1 gün içinde 200$ USD
(10 Değerlendirme)
3.7
SCAnalytics

We are proficient in developing automated Excel-VB tools.

in 2 gün içinde100$ USD
(4 Değerlendirme)
3.5
ivanpuppets

Hi, how are you? Please, see PM.

in 0 gün içinde200$ USD
(4 Değerlendirme)
3.3
cheungkc

Hi I am offering to provide a solution in Excel 2007/Win XP environment. I trust it should not be an issue if end user uses Excel 2010/Windows 7. In the sample files, column headers 36 are not identical, one is i Daha fazlası

in 5 gün içinde150$ USD
(6 Değerlendirme)
3.0
freelancerbuzzo

Ready to start right now.

1 gün içinde 150$ USD
(7 Değerlendirme)
2.8
sumeet00

Hi, I have already worked on this. I have a Dotnet exe ready for this. The only change would be your requirement of the 1st point. I can easily include that as I have the source code. Once that is done,your fi Daha fazlası

in 5 gün içinde80$ USD
(2 Değerlendirme)
2.5
BSoftTech

I can do this using VB tool (merge using MS Office objects for Excel) Thanks, John

in 5 gün içinde200$ USD
(1 Değerlendirme)
2.4
pepiboo

Hi i can do this very easily and efficeintly.

in 5 gün içinde80$ USD
(1 Değerlendirme)
2.3
eyesee

Hello! Hungarian freelancer here, new to the site so don't get fooled by the low feedback ratio, just started working on it :) I just finished a project very similar to this except the program wasn't reading CSV files Daha fazlası

1 gün içinde 120$ USD
(1 Değerlendirme)
1.0