How to display S1234567A as SXXXX567A

[Elson Khoo]

Dear all,

Can someone advise me how can I display Singapore National Registration Identity Card number in special format

from S1234567F as SXXXX567F?

Thank you

 

[Galaxiom]

Left([SNRICN],1) & "XXXX" & Mid([SNRICN],6)

 

[Elson Khoo]

Thank you. It work.

Can explain why Mid([SNRICN],6)? I mean why "6"

Also we change to Right([SNRICN],4) and it work too.

 

[Galaxiom]

Right() can be used instead. Mid is just another way that is useful if the length of the string is not constant..

The second argument of the Mid function is the position of the starting character in the string. An optional third argumentdefines the number of characters to return but it returns the rest of the string if it is omitted.

 

[Elson Khoo]

Thank you very much. I got it now