In Progress

One List -> Two CSV files

Hi,

I need the IANA port list in a new format:

Original:

[url removed, login to view]

Structure:

snagas 108/udp SNA Gateway Access Server

# Kevin Murphy <murphy&sevens.lkg.dec.com>

pop2 109/tcp Post Office Protocol - Version 2

pop2 109/udp Post Office Protocol - Version 2

# Joyce K. Reynolds <jkrey&isi.edu>

pop3 110/tcp Post Office Protocol - Version 3

pop3 110/udp Post Office Protocol - Version 3

# Marshall Rose <mrose&dbc.mtview.ca.us>

Protocolname Port/Type Comment

Desired new format: Two CSV files

First CSV file: [url removed, login to view]

Columns:

- ProtocolId (1,2,3,4,... starting at 5)

- ProfileId (always 'NULL')

- Protocolname (from list above)

- ProtocolTypeId (always 2)

Second CSV file: [url removed, login to view]

Columns:

- PortRangeId (1,2,3,4... starting at 10)

- ProtocolId (from other file)

- NetworkProtocol (either tcp or udp)

- PortRangeStart (number)

- PortRangeEnd (always 'NULL')

Example above:

1st file / [url removed, login to view]

...

5,'NULL','snagas',2

6,'NULL','pop2',2

7,'NULL','pop3',2

...

2nd file / [url removed, login to view]

...

10,5,'udp',108,'NULL'

11,6,'tcp',109,'NULL'

12,6,'udp',109,'NULL'

13,7,'tcp',110,'NULL'

15,7,'udp',110,'NULL'

Important for this job:

- Service provider can start immediately

- Service provider can provide valid invoice (with local tax number or vat code)

Payment through getAFreelancer escrow account.

Kind regards,

Sebastian

Skills: Data Entry, Data Processing, Excel

See more: iana port numbers csv, version one, vat number escrow com, us escrow payment service, post office job .com, post office job, post office data entry, payment processing escrow, list in data structure, list data structure, kevin rose, escrow account in post office, escrow account example, data structure type, data structure through c, data structure list, code escrow service, us vat number, tax job, www escrow service, www escrow account, tax escrow account, escrow tax, escrow payment processing, escrow one

About the Employer:
( 53 reviews ) Fentange, Germany

Project ID: #572289

Awarded to:

BestESolutionsBD

hello Sebastian,ready for the better service than [url removed, login to view] no problem with [url removed, login to view]

$40 USD in 1 day
(53 Reviews)
5.9

2 freelancers are bidding on average $45 for this job

mantislin

Hi sir, Please check PM, Thanks, Kimi.

$50 USD in 1 day
(44 Reviews)
5.7