Last Names starts with S

[JenzEkan]

Hey Guys I have a data set and I want to filter the records whose last name starts with S.

Thanks.

[DataNath]

@JenzEkan you should be able to use a Filter expression with StartsWith([SurnameField], ‘S’) - your records of interest will come out of the top (True) anchor.

[ShankerV]

Hi @JenzEkan 

One way of doing this.

[Felipe_Ribeir0]

Hi @JenzEkan 

One way of doing this

[JenzEkan]

Sorry Guys,

Let me share the data set with you. In case of below data set, please let me know your inputs.

James*Stanford
Henry*Landmark
Mary*Shane*Jane
Sheen*Stans

[grazitti_sapna · Accepted solution]

@JenzEkan , You can do it in 2 ways. I have used both Regex_Match function and regex tool to achieve your desired output. You can consider any based on your requirement.

Using Filter Tool:

Using Regex Tool:

[ShankerV]

Hi @JenzEkan 

Please find the expected output.

[Felipe_Ribeir0]

Hi @JenzEkan 

One way of doing this