Ukończone

Conversion of excel file data format

Input file in spreadsheet format has the following features:

Column A: Name

Column B: numbers delimited with column or comma or showing a range using hyphen.

other columns - random data.

Output file must have format:

Column A: Name

Column B: one number per line

other columns - random data.

Task is to create a macros (preferred) or external application that would convert spreadsheet in requested format: one number per line.

## Deliverables

Example:

input data

<col width="248" style="width: 186pt;" /> <col width="506" style="width: 380pt;" />

| Argentina Corredores | 54221; 54223; 54230; 54232; 54291; 54299; 54342; 54348; 54353; 54358; 54381; 54387 |

output data:

| Argentina Corredores 54221 | |

| | |

| Argentina Corredores 54223

Argentina Corredores 54230 | |

and so forth.

Same rule with comma as delimiter.

If range is shown: 74-80

than 7 lines are created.

In put data can also be mixed:

ColumnA Column B

<col width="109" style="width: 82pt;" /> <col width="210" style="width: 158pt;" />

| 374 | 93-94, 77, 98 |

resulting output should show:

37493

37494

37477

37498

with other data dulicated to each new line.

| |

* * *This broadcast message was sent to all bidders on Tuesday Jun 9, 2009 11:14:14 AM:

The amount of data per converted file varies from few lines to several thousand lines. Generally it should not exceed Excel limit of 56K records.

Umiejętności: Wprowadzanie danych, Inżynieria, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Architektura oprogramowania, Testowanie oprogramowania, Word

Zobacz więcej: data entry argentina, 94.7 entry, external data entry, php argentina, name format, data format, data conversion excel macros, data range, excel random number, excel create input output, php random file name, excel file convert, broadcast limit, input rule, excel file conversion, delimited data, excel file columns, random data, create application excel, convert excel php, excel converted, excel delimited, php data entry format, excel input data, broadcast file

O pracodawcy:
( 3 ocen ) New York, United States

Numer ID Projektu: #3930839

Przyznany użytkownikowi:

desm0ndsvw

See private message.

$9 USD w ciągu 14 dni
(11 ocen)
2.3

22 freelancerów złożyło ofertę na kwotę $39 do tego projektu

fastudiovw

See private message.

$76.5 USD w ciągu 14 dni
(732 Oceny)
7.5
shikhamehta

See private message.

$42.5 USD w ciągu 14 dni
(236 Oceny)
6.8
garex

See private message.

$15.3 USD w ciągu 14 dni
(21 Oceny)
6.6
Premshanks

See private message.

$17 USD w ciągu 14 dni
(344 Oceny)
6.5
NeoNoXtraOrdnry

See private message.

$12.75 USD w ciągu 14 dni
(79 Oceny)
5.5
Robotapps

See private message.

$85 USD w ciągu 14 dni
(93 Oceny)
5.4
satsuravw

See private message.

$25.5 USD w ciągu 14 dni
(38 Oceny)
5.3
Lotusdeveloper

See private message.

$45.05 USD w ciągu 14 dni
(87 Oceny)
5.3
DenisSmolentsev

See private message.

$46.75 USD w ciągu 14 dni
(84 Oceny)
5.2
javaenigma

See private message.

$11.05 USD w ciągu 14 dni
(16 Oceny)
4.9
rajhansh

See private message.

$17 USD w ciągu 14 dni
(18 Oceny)
4.1
kseen

See private message.

$42.5 USD w ciągu 14 dni
(31 Oceny)
3.8
globetechie

See private message.

$85 USD w ciągu 14 dni
(2 Oceny)
2.4
esselvw

See private message.

$25.5 USD w ciągu 14 dni
(4 Oceny)
2.1
vikramtechvw

See private message.

$42.5 USD w ciągu 14 dni
(3 Oceny)
0.1
vw7259603vw

See private message.

$42.5 USD w ciągu 14 dni
(1 Ocena)
0.0
alligators

See private message.

$42.5 USD w ciągu 14 dni
(0 Oceny)
0.0
amitarani

See private message.

$25.5 USD w ciągu 14 dni
(0 Oceny)
0.0
RaduMantale

See private message.

$34 USD w ciągu 14 dni
(0 Oceny)
0.0
onlyforworkvw

See private message.

$85 USD w ciągu 14 dni
(0 Oceny)
0.0