SSIS REGEX CLEAN transformation error
I have used RegexClean Transformation to clean my data
match : [!@#$%^&*_+`{};':,./<>?0123456789](?<empty>)
replace : ${empty}
It is removing the special characters but the only problem is it is giving
me nulls for the rows which are correct So I am little confused why
exactly is this error occuring
NUM VEH NAME NAME_Clean
1 CREDEUR CYNTHIA D NULL
2 FLUKE NANCY C NULL
017 1 CLARK, WILLIAM CLARK WILLIAM
037 2 DESORMEAUX, MICHELLE DESORMEAUX MICHELLE
043 1 FALCON, JENNIFER, FALCON JENNIFER
073 2 WINTERS, ALLEN WINTERS ALLEN
084 1 UNKNOWN NULL
094 2 UNKNOWN NULL
No comments:
Post a Comment