startsWith

Description

Returns true if a string begins with a given substring, otherwise return false.

note

Unlike contains, which checks for a substring anywhere in the string, startsWith only matches the beginning.

Syntax

Like many functions in DataPrime, startsWith supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

startsWith(value: string, prefix: string): bool

Method notation

(value: string).startsWith(prefix: string): bool

Arguments

Name	Type	Required	Description
value	string	true	The full string to test (haystack)
prefix	string	true	The substring to check at the start of the string (needle)

Example

Check if a string is an AWS ARN

AWS ARNs look like this:

arn:aws:s3:::mybucket

To confirm if a value is an ARN, check if it starts with arn::

Example query

Function notation

create is_arn from startsWith(resource_id, 'arn:')

Method notation

create is_arn from resource_id.startsWith('arn:')

Example output

{
    "resource_id": "arn:aws:s3:::mybucket",
    "is_arn": true
}