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

Question

Question

Forms Formula to get parts of string - Laserfiche Cloud

asked on September 22

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 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.