How to separate field values from a field which starts with Letter and 3 digit number?

[Anonymous]

I need to separate field values from a field which have a length of 4 and starts with Letter and 3 digit number. Eg: B101, C253

Please tell me how to achieve this. Thanks.

[michellysodre]

Hi,

Letter: left(values,1)

Number: Right(values,3)

[shraddha_g]

If you want to separate alphabates and numbers and Format is same then you can try michellysodre‌ ch answer.

Else For Numbers :- Keepchar(FieldName,'1234567890')

For Alphabates - Purgechar(FieldName,'1234567890')

[MarcoWedel]

please post some sample data and your expected result.

thanks

regards

Marco

[Anonymous]

Thank You

[Anonymous]

Thank You