Value.contains() - Specific request about the beginning

Support and Helpdesk Data cleaning and transformations
1

Hello,

I use this function value.contains("T-") to capture a line who begin by T-
Exemples (Always directly begin by T) :

T-5 $$$$$$$$$$$$$$$$
T-21 $$$$$$$$$$$$$

Globally it's working but sometimes if I have a line like this for exemple:

$$$$$$$$$$$$$$$ T-word $$$$$$$$$$$$$$$$$$$

And I don't want this line.

Have you a solution to skip this line ?

Thank you

2

You can use the GREL function startsWith() to validate only the beginning of the string - for example, value.startsWith("T-").
You can refer to our documentation for more details.

1 Like