Search results

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

You can 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 using the above syntax. You can see how we separate the names using a space in the following image.

    split expression

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

    split output

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

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