Skip to content

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 notation. These interchangeable forms allow flexibility in how you structure expressions.

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

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

Arguments

NameTypeRequiredDescription
valuestringtrueThe full string to test (haystack)
prefixstringtrueThe 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

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

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

Example output

{
    "resource_id": "arn:aws:s3:::mybucket",
    "is_arn": true
}
Need help? Contact Support.
What's new? Find out here.
LLM? Read llms.txt.
Previous splitParts
Next substr