Sign in to follow this  
Followers 0

Script to remove characters

5 posts in this topic

Posted

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?

Share this post


Link to post
Share on other sites



Posted (edited)

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 ?

:whistle:

Edited by JdeB

Share this post


Link to post
Share on other sites

Posted (edited)

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 ?

:whistle:

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

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Posted

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

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

:whistle:

Share this post


Link to post
Share on other sites
Sign in to follow this  
Followers 0