Split expresssion

[Bagrat_Tsakadze]

Hi

I would like to extract the first part after splitting the sentence by using a SPLIT - function

How define the "extract" function?

[SkrOYC]

Tell us the string, we will tell you the expression

[Bagrat_Tsakadze]

Hi

Actually I have a comments table that is connected to Order table by

"REF_ROWS("Comments", "Comment ID")

I need to find some values from the ORDER - table to see them in Comments Table

That is my goal

[graham_howe]

Or have a look at the help documentation, the split() function is pretty easy to use

	SPLIT()
	List from text

Update to say have a look at index() as well once you have done the split. INDEX() | AppSheet Help Center 

[Bagrat_Tsakadze]

It is really easy, though I need to the the 2nd part I get after SPLITting it: 

4dfb4ea3: 1056

the last four digits represetn an invoice number, I need them along with two more fields from the parent table, to get them in a child table

[Bagrat_Tsakadze]

As long as the invoice number has only four digits it is Ok to get the number by applying LEFT - expression. Though it is not OK in the long run as when the invoice number exceeds 4 digits I willl have to change formula itself

[SkrOYC · Accepted solution]

Try

INDEX(
  SPLIT(
    [The column],
    ": "
  ),
  2
)

[Bagrat_Tsakadze]

Thanks a lot !!!

It workks