# Row, Column, StringColumn

### **Row Class**

The `Row` class represents a single row of data in a table.

#### Methods

* `getString(columnName: String): String` - Returns a string value from the specified column.

```typescript
var stringValueByName = row.getString("ColumnName");
```

* `getString(columnIndex: Integer): String` - Returns a string value from the column at the specified index.

```typescript
var stringValueByIndex = row.getString(columnIndex);
```

* `rowHash(): Integer` - Returns a hash value for the row.

```typescript
var rowHashValue = row.rowHash();
```

* `toString(): String` - Converts the row to a string.

```typescript
var rowAsString = selectedRow.toString();
```

***

### **Column Class**

The `Column` class represents a single column of data in a table.

#### Methods

* `title(): String` - Returns the title or name of the column.

```typescript
var columnTitle = column.title();
```

* `name(): String` - Returns the name of the column.

```typescript
var columnName = column.name();
```

* `size(): Integer` - Returns the number of items in the column.
* `get(rowIndex: Integer): any` - Returns the data value at the specified row index.
* `isEmpty(): Boolean` - Checks if the column is empty.

```typescript
var isEmpty = column.isEmpty();
```

* `print(): String` - Converts the column to a string for printing.'
* `contains(object: any): Boolean` - Checks if the column contains a specific object.
* `type(): any` - Returns the data type of the column.
* `sortAscending()` - Sorts the column in ascending order.

```typescript
column.sortAscending();
```

* `sortDescending()` - Sorts the column in descending order.

```typescript
column.sortDescending();
```

***

### **StringColumn Class**

The `StringColumn` class represents a column of string values and provides various methods for string-specific operations.

#### Methods

#### `equalToIgnoringCase(str: String): Selection`

This method is used to filter the selection based on a case-insensitive comparison with the provided string (`str`). It selects rows in which the values in the column match the specified string while ignoring case differences.

#### `startsWith(str: String): Selection`

The `startsWith` method is used to filter the selection, returning rows where the values in the column start with the provided string (`str`).

#### `endsWith(str: String): Selection`

This method is employed to filter the selection, returning rows where the values in the column end with the specified string (`str`).

#### `contains(str: String): Selection`

The `contains` method filters the selection to include rows where the column values contain the given string (`str`).

#### `matchesRegex(str: String): Selection`

This method allows you to filter the selection using a regular expression. It selects rows where the column values match the provided regular expression string (`str`).

#### `isEmpty(): Selection`

The `isEmpty` method is used to filter the selection to include rows where the column values are empty or null.

#### `isAlpha(): Selection`

This method filters the selection to include rows where the column values consist of alphabetic characters only, excluding digits and special characters.

#### `isNumeric(): Selection`

The `isNumeric` method selects rows where the column values are numeric, consisting of digits and optional decimal points.

#### `isAlphaNumeric(): Selection`

This method is used to filter the selection to include rows where the column values contain both alphabetic characters and digits.

#### `isUpperCase(): Selection`

The `isUpperCase` method selects rows where the column values consist of uppercase letters only.

#### `isLowerCase(): Selection`

This method is used to filter the selection to include rows where the column values consist of lowercase letters only.

#### `hasLengthEqualTo(lengthChars: Integer): Selection`

The `hasLengthEqualTo` method filters the selection to include rows where the column values have a length equal to the specified `lengthChars`.

#### `hasLengthLessThan(lengthChars: Integer): Selection`

This method selects rows where the length of the column values is less than the specified `lengthChars`.

#### `hasLengthGreaterThan(lengthChars: Integer): Selection`

The `hasLengthGreaterThan` method is used to filter the selection to include rows where the length of the column values is greater than the specified `lengthChars`.

These methods provide a variety of ways to filter and manipulate data in a `StringColumn`, allowing you to tailor your selections based on specific criteria and conditions.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.b2winsuite.com/5.2/scripting/data-types-and-data-structures/row-column-stringcolumn.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.