You are viewing limited content. For full access, please sign in.

Question

Question

Forms Formula to get parts of string - Laserfiche Cloud

Forms Laserfiche Cloud
Updated September 22, 2022
asked on September 22, 2022

Hello,

 

I have a Lookup field which has the value: Text-Number-Number

I want to split this in different fields & was wondering if someone could help with Formula?

 

My intention is to create 3 fields & give formula in them to split, I am sure "-" can be trigger to split, but I am not able to get it.....

 

Can someone please help?

 

Regards,

S

0 0

Answer

SELECTED ANSWER
replied on September 22, 2022 • Show version history

Try something as "=INDEX(SPLIT({lookupfieldvariable},"-"),1)"(replace {lookupfieldvariable} with the actual variable name), it can get the Text from Text-Number-Number

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...