Devam Ediyor

Script or Macro to re-format bar delimited text

The project is to provide a script (that can run on OSX Lion) or macro (than can run in Open Office Calc for Mac).

An example file "[url removed, login to view]" is the file that is referenced in"[url removed, login to view]". The licence is also attached that pertains to the attached data.

The processed file needs to be a .csv file with no artifacts (e.g. ' or " or , or [space] or | or -> [tab] any redundant data removed) only the required " and , to generate the .csv file.

The headers must be in conformance with the Metadata file.

There must also be two (2) columns added. the first, a concatenated column with the lot_noplan_no (e.g. 1RP124527) and the second column will be the concatenated address.

With regards to generating a complete address columns these columns shall be used (unit_no|unit_suf|street_no_1|str_no_1_suf|street_no_2|str_no_2_suf|road_name|road_type|road_part|locality_name)

when generating the address for each column there script shall skip any -Empty- fields as not to generate in-valid address records. Where there is an address with a range (street_no_2|str_no_2_suf). The range needs to be split up to and the numbers between generated.


BUP11491 9 9 37 A 39 C

should generate

BUP11491 9 9 37 A

BUP11491 9 9 38 B

BUP11491 9 9 39 C

and the address columns will then be

address lotplan

9/37A road_name road_type road_part (if any), locality_name 9BUP11491

9/37B road_name road_type road_part (if any), locality_name 9BUP11491

9/37C road_name road_type road_part (if any), locality_name 9BUP11491

You must also remember that this is just an example where there is a unit_suf this must also be repeated like the lot_no and plan_no above.

I would ask that you test using the provided .gz file and provide an output example for me to validate on my end prior to release of final payment.

N.B. In each file there is up to 1,000,000 rows

Please PM for any extra questions.

Beceriler: Veri Madenciliği, Veri İşleme, Javascript, Python

Daha fazlasını gör: project calc, python end, javascript data format, the lion, office macro, macro, macro e, gz, Calc, bar file, macro script file, tab delimited text, validate python, script mac, tab delimited format, generate project file macro, python validate, csv column format, space office, file mac format, project macro, osx script, delimited data, script osx, column text

İşveren Hakkında:
( 10 değerlendirme ) Brisbane, Australia

Proje NO: #2239111