Guidance with finding and replacing via inputted variable from text

Jul 19, 2013 at 9:46 PM
Can someone give me some guidance on whether or not this tool might assist me with the following? I have Excel spreadsheets that have SSN's in them that I want to replace with a PeopleID. I have a text file that has the SSN and PeopleID equivalent. I am looking for a tool that can read the SSN from a text file, look through files in a folder (mainly excel files), and replace with the equivalent PeopleID, and then move on to the next file. Possible to use this tool to do this, if so, any guidance on how to do so, or a suggestion on another tool.

Thanks!
Coordinator
Jul 23, 2013 at 1:56 PM
Hi,

I think you need someone to write a little program or script to do this.

Let me know if you are looking for developers to help with this.

Eric
Jul 23, 2013 at 10:35 PM

Might be interested in someone developing this. Why don’t you email me at [email removed] and we can communicate about this.

Shawn Romine
Information Technology Manager
The Ford Family Foundation
1600 NW Stewart Parkway
Roseburg, OR 97471
(541) 957-2579 direct
(541) 957-5720 fax
www.tfff.org