Find Jobs
Hire Freelancers

A macro to extract address out of CSV file to OpenOffice Write

$10-30 USD

Stengt
Lagt ut over 9 år siden

$10-30 USD

Betalt ved levering
I have a csv file with address data in. I need the macro /script etc... to export some house / flat address data and export it to Open Office Writer to a label format for printing. The macro needs to be inteligent so it needs to be able to do the following: Example of fulll address in the UK / England: PAON is the first field required, this could be a number or a house name either 111 or Nelson House ( ignore if blank) SAON is the second field required which for example is Flat 1 (This for Flats only and will be ignore if blank) Street is the third field which could be Devises Road ( ignore if blank) Locality is the fourth field and will be text like Wilton ( ignore if blank)) TownCity this is the fifth field and is the town or city for example Salisbury ( ignore if blank) County is the sixth field and is the County for example Wiltshire ( ignore if blank) Postcode is the seventh field and is the postcode for example SP2 7JN ( ignore if blank) * If fields Locality, TownCity or County are exactly the same only export one of them, no repeats please! The macro needs to be inteligent and export the following 2 Examples and any address in the correct order and with no blank lines otherwise this looks unprofessional when printed on lables: EXAMPLE 1 The OUTPUT 1 below is achieved by exporting for line 1 PAON ignoring SAON because its empty i.e its not a Flat, then Street is on the same line as PAON. Locality is on line 2 TownCity is on line 3 County is on line 4 Postcode is on line 5 * If fields Locality, TownCity or County are exactly the same only export one of them, no repeats please! OUTPUT 1: 111 Devises Road Salisbury Wiltshire SP2 7JN EXAMPLE 2 (Flats are different addresses to houses and the Flat Field must always come first): The OUTPUT 2 below is achieved by exporting for line 1 SAON PAON and Street on line 2 Locality is on line 3 TownCity is on line 4 County is on line 5 Postcode is on line 6 * If fields Locality, TownCity or County are exactly the same only export one of them, no repeats please! OUTPUT 2: Flat 1 63 Devises Road Salisbury Wiltshire SP2 7LQ * The Macro needs to deal with a csv file that may have 7 fields or 16 fileds in total, so it will have to be inteligent to find the fields above mentioned. Any questions please ask me. Have a great day!
Prosjekt-ID: 6141034

Om prosjektet

4 forslag
Eksternt prosjekt
Aktiv 10 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
4 freelancers are bidding on average $161 USD for this job
Brukeravatar
I can deliver the macro to your specifications and needs after further discussion .
$210 USD om 3 dager
5,0 (6 omtaler)
4,5
4,5
Brukeravatar
Hi, I have several years experience of using Excel and VBA to produce management and business information from underlying data. These are the solutions which I provide to the firms, which saves their substantial amount of effort, cost and time. Data reconciliation Data Collation Data Segregation Data formatting Data allocation Reporting macro Dynamic Pivot table modification Dashboard Any requirements, let me know. Thanks, Arjun Singh M: 9930073163
$25 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED KINGDOMs flagg
United Kingdom
5,0
4
Betalingsmetode bekreftet
Medlem siden des. 2, 2005

Klientbekreftelse

Lignende jobber

mathematical script - count distinct numbers in arrays subject to certain conditions -- 3
$10-30 USD
mathematical script - count distinct numbers in arrays subject to certain conditions -- 2
$10-30 USD
mathematical script - count distinct numbers in arrays subject to certain conditions -- 4
$30-250 USD
mathematical script - count distinct numbers in arrays subject to certain conditions
$30-250 USD
mathematical script - count distinct numbers in arrays subject to certain conditions -- 2
$10-30 USD
Script to Add 7 Days to a Date in a Table
€8-30 EUR
Qrexorder & QPOS I want a nulled script
$30-250 USD
EDITH glasses from instructables
$15-25 CAD / hour
Qrexorder & QPOS I want a nulled script
$30-250 USD
mathematical script - count distinct numbers in arrays subject to certain conditions -- 4
$30-250 USD
mathematical script - count distinct numbers in arrays subject to certain conditions -- 6
$10-30 USD
EDITH glasses from instructables
$15-25 CAD / hour
mathematical script - count distinct numbers in arrays subject to certain conditions -- 6
$10-30 USD
mathematical script - count distinct numbers in arrays subject to certain conditions
$30-250 USD
mathematical script - count distinct numbers in arrays subject to certain conditions -- 3
$10-30 USD
Develop Custom APK / or ROOT
$30-250 USD
Develop Custom APK / or ROOT
$30-250 USD
Script to Add 7 Days to a Date in a Table
€8-30 EUR
mathematical script - count distinct numbers in arrays subject to certain conditions -- 2
$10-30 USD
Script to Add 7 Days to a Date in a Table
€8-30 EUR
Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.