Fungsi SQL BigQuery

Extracts all substrings that match the regular expression and returns them as an array.

Returns the position (1-based) of the substring that matches the regular expression. Returns 0 if there is no match.

Replaces all substrings that match the regular expression with a replacement string. Supports backreferences.

Alias for REGEXP_EXTRACT. Extracts the substring that matches the regular expression.

Repeats a string n times. Useful for generating patterns.

Replaces all occurrences of a substring with a new string. Replacement is case-sensitive.

Reverses the order of characters in a string. The first character becomes the last and vice versa.

Extracts a specified number of characters from the right (end) of a string. A more readable shorthand for extracting trailing characters.

Pads the right side of a string with characters until it reaches a specified length. Right padding.

Removes characters from the right side (end) of a string. Right trim for trailing characters.

Safely converts a BYTES value to a STRING, replacing any invalid UTF-8 characters with the Unicode replacement character instead of raising an error.

Mengembalikan email address dari user yang menjalankan query.

Menghitung SHA-1 hash dari input. Return BYTES.

Menghitung SHA-256 hash dari input. Aman untuk kriptografi.

Menghitung SHA-512 hash dari input. Hash paling kuat di keluarga SHA-2.

Splits a string into an array based on a delimiter. Very useful for parsing CSV-style data.

Checks whether a string begins with a specified prefix. Returns a boolean.

Finds the first position of a substring within a string. A simplified version of INSTR.

Extracts a portion of characters from a string starting at a specified position. An alias for SUBSTRING, highly useful for data extraction and parsing.

Extracts a portion of characters from a string. Identical to SUBSTR, available for standard SQL compatibility.

Converts a STRING or BYTES value into an array of code points (Unicode code points for STRING, values 0-255 for BYTES).

Replaces each character from the source character set with the corresponding character in the target character set. Character-level translation.

Removes characters from the beginning and end of a string. By default, removes whitespace.

Converts all characters in a string to uppercase. Supports Unicode characters.