Ignore bad rows - not alphanumeric RRS feed

  • Question

  • I need to ignore or redirect bad rows (i.e. contain special characters)

    I have tried using a conditional split component but I do not know what special characters I may receive in my data source. They vary from (but not restricted to) the following:



    I know that that I can use a script component and a REGEX to match various patterns but what I need to do is the following:

    Ignore rows where primary keys fields only have alphanumeric values (as my primary key values cannot contain NULL and will not parse when a special character exists)

    However, my primary key fields are Date, Time and Site so I also need the REGEX pattern to allow '/' and ':' and '.' for Date and Time (with precision)

    If the special character only exists in Site and not Date or Time, I can replace with "" and process the row.

    Can this be done using REGEX and script component?

    • Edited by DapperDev_ Wednesday, July 22, 2015 2:19 PM
    Wednesday, July 22, 2015 1:49 PM


All replies