How can i retrieve only particular length of a text from particular colum

I have sample db like this

here i want to retrieve only Card colum for last 4 digit alone. I have used the below formula but it returns the whole data

But i was success with other filterByFomula like searching InActive members from Status col like this

Please help me to resolve