CSV Conversion Program

Completado Publicado Apr 8, 2007 Pagado a la entrega
Completado Pagado a la entrega

Overview: Need a windows program that will convert a .csv into another .csv with a specific format and defined preferences set forth below. See enclosed: * What needs to be converted ([url removed, login to view]) * What it should be converted to ([url removed, login to view]) * Specific parameters needed (look-up...csv) I should be able to drag and drop any amount of "[url removed, login to view]" and convert each to new type. The program should allow me to specify certain fields. There are also certain conversions required. Details: 1. When a set of .csv (1 or many) are dragged into the "conversion bucket", there should be a dialog to allow me to specify all cells for column A, B, C, F, G, H, I (see [url removed, login to view] in EXCEL) for EACH first-format.csv. This specification is then duplicated in all rows until end of new. 2. Values from "[url removed, login to view]" are then converted into the new .csv for columns as followed: * Row 1 is deleted from [url removed, login to view] and replaced with row 1 in converted-format.csv. * Column C for [url removed, login to view] => Column D for new [url removed, login to view] ... * Column D => L * E => K * F => M * G => P * H => Q * J => N * K => O 3. For column E in [url removed, login to view], there needs to be a special conversion. Instead of "city; ST", there needs to be a look-up functions that splits the column into two columns with parameters: * Currently, see "[url removed, login to view]". Data in column F should be "split" by separating "; ". The 2 letter abbreviation is dropped into column 1, and the new ST is created in column 2. See "[url removed, login to view]". This function needs to be added into the program. Excel formula is available in column 3. * Then, "ST" => Column J for new .csv * "City" => Column K Thank you.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows, Excel (if necessary). .net (if necessary)

PHP

Nº del proyecto: #2915378

Sobre el proyecto

16 propuestas Proyecto remoto Activo Apr 8, 2007

Adjudicado a:

barreiro04

See private message.

$102 USD en 7 días
(22 comentarios)
3.7

16 freelancers están ofertando un promedio de $150 por este trabajo

pShankar2

See private message.

$85 USD en 7 días
(415 comentarios)
7.1
schandraram

See private message.

$255 USD en 7 días
(165 comentarios)
6.9
brsofts

See private message.

$136 USD en 7 días
(288 comentarios)
6.7
bitdonkey

See private message.

$140.25 USD en 7 días
(120 comentarios)
6.3
Iwin

See private message.

$425 USD en 7 días
(62 comentarios)
5.7
AncaU

See private message.

$85 USD en 7 días
(115 comentarios)
5.4
somireddy

See private message.

$85 USD en 7 días
(77 comentarios)
5.2
ysrahmed

See private message.

$127.5 USD en 7 días
(62 comentarios)
4.9
erikhumala

See private message.

$85 USD en 7 días
(94 comentarios)
4.8
PixelSOFT

See private message.

$123.25 USD en 7 días
(61 comentarios)
4.8
isturk

See private message.

$272 USD en 7 días
(28 comentarios)
4.7
iak8

See private message.

$170 USD en 7 días
(6 comentarios)
4.1
GInfolab

See private message.

$85 USD en 7 días
(1 comentario)
2.8
veenananda

See private message.

$127.5 USD en 7 días
(4 comentarios)
2.0
sean0101a

See private message.

$102 USD en 7 días
(0 comentarios)
0.0