So, I have some data that has to be 9 digit integer, however, some of them have A or W or E at first and then 9 integers and some of them have other letters, sometimes two letter at the end of 9 digits.
I tried to use accel and this command:
Left([Field],9) in the update section, but it only...