Filtering GL account

[SH_94]

Dear Community,

May i know how can i filter the 17 and 18 series account for the data below:

Data

1. 1202121

2. 1493939

3. 1739393

4. 18r2jroi2

5. 17jei020

6. 2170292

Results 

1. 1739393

2. 18r2jroi2

3. 17jei020

Many thanks for the help

[MarqueeCrew]

how about trying a filter:

Left([Data],2) in ("17", "18")

Cheers,

Mark

[SH_94]

Dear @MarqueeCrew ,

It seems like i can't get the desired result.

Maybe different format needed

[MarqueeCrew]

Can you show us the real data?  

[Shubhamarora]

Hey, 

I have found the solution to your problem. You can simply use a formula tool and substring function to find the desired result. I have attached the workflow. I hope you find it useful. 

Thanks