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:

Right_A

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

Help

Accepted answers

ShankerV

Hi @ShantanuDagar

Then this works.

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

Stream1:

Stream 2:

Many thanks

Shanker V

All comments

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:

Right_A

Right_Right_B

All normal names in 1 stream.

All Right_ prefixed names in 2nd stream.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703