Filter based on prefix

[ShantanuDagar]

Hello,

I am looking help on building a logic to filter based on Right_ prefix

I have a transposed a dataset which was joined earlier.

Need to separate normal names and Right_(Names)

So want to build a filter which does the same:

A

Right_A

B

Right_B

71_ABC

Right_71_ABC

Just an example that after Right_ it can be alphabets or number too or a combination of number and string like 71_ABC.

Thanks

[ShankerV]

Hi @ShantanuDagar 

Can you please let us know what is the expected output.

[ShankerV]

Hi @ShantanuDagar 

Please check whether you are looking something like this.

Left([Field1],5)= "Right"

Many thanks

Shanker V

[Christina_H]

If they've all been renamed with the Right_ prefix, just use that in a filter.

Left([Name],6)="Right_"

[ShantanuDagar]

Expected output would be: 

2 separate streams:

A

B

.

Right_A

Right_Right_B

.

All normal names in 1 stream.

All Right_ prefixed names in 2nd stream.

[ShankerV · Accepted solution]

Hi @ShantanuDagar 

Then this works.

Left([Field1],5)= "Right"

Stream1:

Stream 2:

Many thanks

Shanker V