Script to remove characters

[Mucho]

I need some expert help. I copied a chunk of text into a notepad like this:

John Doe Client Name 2:

CDP A/C Status: A CDP Last Updated: 19960604

GSA No.: A1681 - 0539 - 0731 NRIC/Passport No.: 0062073D

Nationality: 1 Birthday Date: 0

Marital Status: RSD Address 1: 999 CASHEN ROAD

RSD Address 2: #14-10 RSD Address 3:

PostCode: 112233

I need a script to automate removing the unnecessary data so that it becomes like this:

John Doe

999 CASHEN ROAD

Jamestown 112233

Can someone pls help?

[Jos]

2 questions:

1- You want this written in AutoIt version 2 or did you pick the wrong Forum?

2- What have you attempted yourself and where did you get stuck ?

Edited July 6, 2007 by JdeB

[Mucho]

2 questions:

1- You want this written in AutoIt version 2 or did you pick the wrong Forum?

2- What have you attempted yourself and where did you get stuck ?

1) I would like it written in AutoIt v3. I am using the latest version.

2) My programming skill is not quite up to it and character handling, like searching for specific characters is my weak area but

I need to get this job done soon.

I hope you can help.

Edited July 6, 2007 by Mucho

[MisterBates]

1) I would like it written in AutoIt v3. I am using the latest version.

2) My programming skill is not quite up to it and character handling, like searching for specific characters is my weak area but

I need to get this job done soon.

I hope you can help.

Could be quite simple with RegExp functions *if* you had one label followed by a colon followed by the data for that label on a line, but most of the lines you show have two labels/fields per line. Can you get the data in a better format - is there any option to "export" to a CSV or tab-separated file for example?

[Jos]

I have no issues helping but will not write it for you ...

Will move this thread to the V3 support forum soon..