Need help pulling data on field

[chadski021]

I need help pulling data on field

check;L10; result should be L10 or check;check;L1 result should be L1 .

[comment]

If your field contains "check;L10;" then:

RightWords ( YourField ; 1 )

will return "L10". If your field contains "check;check;L1" then the same calculation will return "L1". Hopefully that's what your question is about.

Another option (in case the the expected value can contain several words):

Let (
values = Substitute ( YourField ; ";" ; ¶ ) 
;
GetValue ( values ; ValueCount ( values ) )
)

 

[chadski021]

24 minutes ago, comment said:

Let ( values = Substitute ( YourField ; ";" ; ¶ ) ; GetValue ( values ; ValueCount ( values ) ) )

This helps me thanks.