How to split the first part of a name from the name column

You can able to split the first part of a name from the name column by using the following syntax which only works with PostgreSQL connections.

Syntax: SPLIT_PART(([Column Name]) , ' ', 1)

Follow these steps to split the first part of a name from the name column:

1. First, you need to create an expression by using the above syntax, and you can see how we separate the names using space in the following image.

   

2. Then, you need to configure this expression column to your grid widget. Once, you bind the generated expression in your grid, it will show the first name from the full name.

   

3. Similarly, you can able to split the second part of the name from the name column by using the following:

   Syntax: SPLIT_PART(([Column Name]) , ' ', 2)