# GS-Base 19.5 has been released

**URL:** <https://community.citadel5.com/t/gs-base-19-5-has-been-released/203>\
**Category:** GS-Base Updates\
**Created:** [July 10, 2023, 10:31pm UTC](https://community.citadel5.com/t/gs-base-19-5-has-been-released/203 "2023-07-10T22:31:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![citadel\_5](https://community.citadel5.com/letter_avatar_proxy/v4/letter/c/b2d939/32.png) [@citadel\_5](https://community.citadel5.com/u/citadel_5)\
**Post date:** [July 10, 2023, 10:31pm UTC](https://community.citadel5.com/t/gs-base-19-5-has-been-released/203/1 "2023-07-10T22:31:17Z")

</div>

New features in GS-Base 19.4:

- Using regular expressions as the field validation patterns.  
You can now specify both calculation formulas and regular  
expressions patterns in the “Field Setup \> Validation” field.  
GS-Base will verify whether the data entered in a given field match  
exactly such patterns.  
Validation regex can be often much simpler than the corresponding  
formula for example, to allow entering only phone numbers  
(like: 123-45-678), you can use:

[0-9]{3}-[0-9]{2}-[0-9]{3}

For a field with country codes: [A-Za-z]{3}

[https://citadel5.com/help/gsbase/field\_validation.png](https://citadel5.com/help/gsbase/field_validation.png)

This validation method is also used commonly for HTML forms online  
and you can copy any existing web validation regular expressions  
to GS-Base.

- Using regular expressions as the field conversion patterns.  
To automatically convert the entered data, GS-Base can use  
the standard regular expressions. Again, it can vastly simplify  
such conversions performed previously by the use of formulas.  
To specify regex for the data conversion you need to enter two  
expressions separated by a comma. Such regular expression pairs  
are the exact counterparts of the find-and-replace expressions  
described in details in the “Full Text Searches and Replacing”  
manual/help topic.

\s+,- replaces multiple spaces between words with -

(\b\w)(\w\*(\W+|\z)),\1 creates abbreviations consisting of first letters of words

(\b\w(\d\*))(\w\*(\W+|\z)),\1 creates abbreviations consisting of first letters of words, leaves full numbers

[https://citadel5.com/help/gsbase/field\_conversion.png](https://citadel5.com/help/gsbase/field_conversion.png)

- To resize multiple columns or rows by dragging the header splitter  
line, you can now select a range of cells and all columns or rows  
within that range will be automatically resized as well.
- A bug fix: if a given table field contained multiline text with newline  
\n or \r characters and the “Allow empty matches” option was turned on,  
applying the regular expression Find-And-Replace (also via scripts) function  
can “freeze” GS-Base.