07-29-2020 04:58 AM
I have a list of postcodes polygons, with the postcode attribute such as AB12ABC, AB32CDA and A12ABC, A56DFH. I am using Analytical Merge on All AB and A postcode polygons, outputting geometry and I want to also output the postcode area, being AB & A in this case.
Is there a functional attribute that will extract the first letter characters from the text string? So will extract up to the first instance of a number character. This could be a single letter pair or single letter character.
For my case, i have a simple work around, but am interested in this anyway. Thanks
07-30-2020 12:49 AM
Thanks @hesrah however as I have differing letter characters and differening lengths of letter characters, the LEFT, RIGHT, SEARCH, TRIM, FIND, etc won't return the required characters.
Further examples of the postcodes are
07-30-2020 02:02 AM - edited 07-30-2020 02:15 AM
You can use the SEARCH function to look for the first number (part of collection ).
The complete function would than be:
Does this answer the question?