<div>
Solved from external source.
</div>


<div>
<div class="content wysiwyg-content">
One of the columns of a table I am querying contains a listing of identifiers, they are string and contain one numeric. The strings are varying lenghts. The numeric can occur in the 2nd or 3rd position of the string, such as K1AB, LL4A, W1AQ, JJ2QWE, etc. <br />
<br />
<br />
I am trying to select from the table, one of the columns of my query I want to contain the alpha characters before the numeric, one column to contain the numeric, and the other to contain alphas after the numeric. So using the examples above, I wish to have three columns that contain K 1 AB, LL 4 A, W 1 AQ, JJ 2 QWE. <br />

</div>
</div>


One of the columns of a table I am querying contains a listing of identifiers, they are string and contain one numeric. The strings are varying lenghts. The numeric can occur in the 2nd or 3rd position of the string, such as K1AB, LL4A, W1AQ, JJ2QWE, etc. 


I am trying to select from the table, one of the columns of my query I want to contain the alpha characters before the numeric, one column to contain the numeric, and the other to contain alphas after the numeric. So using the examples above, I wish to have three columns that contain K 1 AB, LL 4 A, W 1 AQ, JJ 2 QWE. 


Open Office Base:  How to select alpha characters before and after numeric in column value.

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

LibreOffice

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.