5 Replies Latest reply on Oct 17, 2018 8:04 AM by Duane Wilson

    Split at Integer and Space

    Duane Wilson

      I have a field of data that I need to split in a specific way.  Most of the field contains one or two letters and then a space and then a series of numbers (i.e. AC 05342 or A 23423).  However, some of the data has one or two letters followed directly by an integer (AC05342 or A23432).  I would like to split the field at the letter and I would like to do it whether there is a space or an integer following directly after the first letter or letters.  Splitting after the space is easy and I have already done it in a few different ways (using a calculated field or the automatic split function).  Any ideas on how to split the field when I encounter an integer in the 2nd or 3rd space?