Post reply

Conditional Split: filter on part of a word in the field

  • January 13, 2020 at 12:08 pm

    #3714866

    Good morning all,

    I start with SSIS and I try to do tests.

    I have a question about filters.

    Here I have a flat csv file as source.

    I have to make filters (conditional split).

    The first filters are simple: <nomchamps> == "Workstation" || <nomchamps> == "Server"

    I have to do a filter on Administrator, Administrator, Administrador, I thought I could do <nomchamps> == "Administra %%" but it does not work

    or groups that start with ASV <nomchamps> == "ASV %%" and that's where I block.

    Could you help me?

    thank you so much

  • January 13, 2020 at 2:00 pm

    #3714903

    I think you need to use FINDSTRING().

    FINDSTRING(nomchamps, "Administra",1) > 0

    should work.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply