Replace values in a variable length field

[QFanatic]

hi all

I have a variable length field, lets call it AcNum, I want to ONLY keep the first 4 characters of the string and replace the rest with '*'

So...

abcd789 would become abcd*** and

asdfghjk will become asdf****

Thank you

[MindaugasBacius · Accepted solution]

What about formula:

=Left('abcdefgh', 4) & Repeat('*', Len('abcdefgh') - 4)

The result is as following: