how to slice data starting with a string

Hi There,

Wanted to know exactly when to slicing , is there a way to slice / filter the data column starting with a particular string.

 

Ex. If we say I have voucher series starting with SOIDV (Column : SOIDV123, SOIDV124, SOIDV125....etc)

where in I just wanted to filter out data starting with SOIDV.

 

 

 

0 2 74
2 REPLIES 2

Please try CONTAINS(), something like 

CONTAINS([Voucher Number Column], "SOIDV")

CONTAINS() - AppSheet Help

 

Steve
Platinum 4
Platinum 4
Top Labels in this Space