How can I filter the word that start with certain number or alphabet?

[kds825]

Hi,

As I wrote in the subject, how can I filter the word that starts with "certain number or alphabet"?

For example, I want to filter the account number that starts with "3" ( 3101, 3102 3103)

Account No
3101
3102
3103
4204
4205
4206
4207

[MarqueeCrew]

@kds825 ,

 did you try Startswith(). ?

StartsWith

StartsWith(String, Target, CaseInsensitive=1): Checks if a string starts with a particular string. Returns True if String starts with a particular string Target, else returns False.

Example

StartsWith('ABC123', 'ABC') returns True.

StartsWith('ABC123', 'abc') returns True.

StartsWith('ABC123', 'abc', 0)returns False.

cheers,

 mark

[sparksun · Accepted solution]

Yes,Startswith function will do it

[Qiu · Accepted solution]

@kds825 
We can use the Startwith function or use the left function with length =1 😊

[kds825]

Hi

@Sparksun @Qiu

Thanks for your help. 

I just wonder why this function is not working.

left([Account No], 1) = 3

Because does the function "left" only work for the String?

[vpogaku]

Hi Qui,

What if I have to filer multiple values starting with different numbers and alphabets?

StartsWith(ToString([policy_number]),'5','8','9','X') - This is not working.

AccountNo

-------------

25565666

16756756

35435436

64543543

67657567

89766666

56767688

96757655

X6547777

A5477675

OUTPUT: 

-----------

56767688

89766666

96757655

X6547777

Thanks 

VJ

[sparksun]

REGEX_Match([AccountNo],"[589x]\d+")

[vpogaku]

Thank you.