Recent content by sharzi

  1. S

    Remove numbers in middle of field ?

    How to use function?
  2. S

    Removing the first letter and sometimes last letter of a 9 digit number

    Thanks. Can you tell me how can I use codes?
  3. S

    Remove numbers in middle of field ?

    Can someone tell me if we have some condition that we don't want to apply left or right to those conditions then what we should do?
  4. S

    Removing the first letter and sometimes last letter of a 9 digit number

    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...
Back
Top Bottom