Questions on IDEA Analysis
Comparing 2 Databases completely
Forums
I have some tasks for which i am using IDEA to import and export data. At the end of the task i need to check whether the exported files are exact replica of the initial databases (Strucutre is the same, but the content needs to be verified) when later imported again in IDEA by someone else.
I know IDEA has a function for comparing databases that but that seems limited on the limited number of fields. I want to check all fields for all records in 2 databases, was hoping for an easy solution to exist any starting point taken in that area?
- Read more about Comparing 2 Databases completely
- 3 comments
- Log in or register to post comments
Removing particular characters
Forums
Hi Brian,
This is cool resources. Thanks!
Do you have functions to remove certain words/characters.
Example: Address field to be removed any "ST." or "STREET" or "STR".
The characters that need to be removed can be located anywhere within an address.
Really need your help. Many thanks.
- Read more about Removing particular characters
- 7 comments
- Log in or register to post comments
Identifying Duplicates using @SoundsLike
Forums
I can use @SoundsLike to find matches to static strings I enter into the equation or two fields on the same record. But I don't know how to use @SoundsLike to match any one record with any similar record in the same file because I don't know how to reference the same field from two records as parameters to the function. Any suggestions? Is what I'm trying to do possible?
- Read more about Identifying Duplicates using @SoundsLike
- 7 comments
- Log in or register to post comments