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

[Still-Learning]

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

[Still-Learning · Accepted solution]

Solved myself like this

Kodular Community – 24 Jul 22

How to get Last 4 digit from airtable

Or another approch Next to the card field, just create another field with fomula and enter this formula So automatically create the required value and new entry also will assign automatically and retrieve the new col value alone… V.Simple ...