Fungsi String BigQuery

Returns the ASCII value (code point) of the first character in the string.

Mengembalikan jumlah bytes dari STRING atau BYTES value.

Returns the number of characters in a string. An alias for LENGTH, available for standard SQL compatibility.

Converts a Unicode code point value into a string character. The inverse of the ASCII function.

Converts an array of code points (extended ASCII 0–255) into BYTES.

Converts an array of Unicode code points into a STRING.

Concatenates two or more strings into one. A foundational string concatenation function in BigQuery that supports multiple data types.

Checks whether a string contains a specified substring. Case-insensitive and supports JSON structures.

Checks whether a string ends with a specified suffix. Returns a boolean.

Menghitung fingerprint menggunakan algoritma FarmHash. Sangat cepat dan cocok untuk BigQuery.

Formats values into a string based on a format string (similar to printf). Supports a wide range of format specifiers.

Menghasilkan UUID (Universally Unique Identifier) versi 4 secara random.

Capitalizes the first letter of each word and lowercases the rest. Title case transformation.

Finds the position of a substring within a string. Supports searching from a specific position and locating the nth occurrence.

Extracts a specified number of characters from the left (beginning) of a string. A more readable shorthand than SUBSTR for extracting leading characters.

Returns the number of characters in a string. For BYTES, returns the number of bytes.

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

Pads the left side of a string with characters until it reaches a specified length. Left padding.

Removes characters from the left side (beginning) of a string. Left trim for leading characters.

Menghitung MD5 hash dari input. Return BYTES.

Normalizes a Unicode string to a canonical form. Useful for consistent string comparisons across different Unicode representations.

Normalizes a Unicode string and applies case-folding for correct Unicode-aware case-insensitive comparisons.

Returns TRUE if the value matches the regular expression. Useful for pattern matching and format validation.

Extracts the first substring that matches the regular expression. If the pattern has a capturing group, returns that group instead.

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.