markj2009 Posted January 7, 2011 Share Posted January 7, 2011 Good Afternoon, If this has been answered previously, I appologise, I did not have much luck in a search. I would like AutoIT script to search a .doc or .txt document finding the Social Security number of individuals and then deleting it, taking care of this through the whole document. It can be done with macro, but that only goes for like 10 lines then you have to click on the macro again to go the next 10 searches. I have tested scripts in AutoIT that I have found that find and replace... but not delete entire text: SSAN: XXX-XX-XXXX Link to comment Share on other sites More sharing options...
iamtheky Posted January 7, 2011 Share Posted January 7, 2011 (edited) look at stringregexpreplace Edited January 7, 2011 by iamtheky ,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-. |(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/ (_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_) | | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) ( | | | | |)| | \ / | | | | | |)| | `--. | |) \ | | `-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_| '-' '-' (__) (__) (_) (__) Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted January 7, 2011 Moderators Share Posted January 7, 2011 markj2009,SRER is not the easiest thing to pick up quickly, so here is how you might you go about it. Read the content of the file with FileRead.Then run this SRER on the text:$sText = "Tom SSAN: 111-11-1111, Dick SSAN: 222-22-2222, Harry SSAN: 333-33-3333" ; This is the magic line <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< $sNewText = StringRegExpReplace($sText, "( SSAN: \d{3}-\d{2}-\d{4})", "") MsgBox(0, "Result", $sNewText)Finally rewrite the file with FileWrite.Give it a go and see how you get on. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now