4 replies to this topic

[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 by JdeB, 06 July 2007 - 06:57 AM.

[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 by Mucho, 06 July 2007 - 08:14 AM.

[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..