Core to our product is the ability to replace clauses within original client documents, with more suitable replacement clauses.

We require the ability to locate some text within a paragraph.

The task concerns the implementation of a function, whose inputs are a search and a chunk of text. The response from the function should contain the start and end character indexes of the search within the text, where they can be found.

The task steps:
Implement the business logic for this function using any language you prefer (this can be swapped within coderpad). The following cases should be handled:

Where the whole search is contained within the text
Where the search ends with some of the start of the text
Where the search starts with some of the end of the text
Test Cases
Case 1: Whole search

Search: You agree to hold and treat data in the strictest of confidence.

Text: This is a legal document. You agree to hold and treat data in the strictest of confidence. If you are in agreement, please sign.

Result: 26, 89

Case 2: End of search at beginning of text

Search: This Confidentiality Agreement is governed by, and shall be construed in accordance with, the laws of England. You

Text: the laws of England. You agree that the courts of England have jurisdiction to settle any disputes.

Result: 0, 23

Case 3: Beginning of search at end of text

Search: the strictest of confidence. If you are in agreement, please sign.

Text: This is a legal document. You agree to hold and treat data in the strictest of confidence.

"""

Given an API running on http://localhost:8000 (see server/index.js for API docs and how to run) we are required to implement a function that: 
Given a table we need to retrieve its data and show the data pivoted by the input rows and columns.

Examples:
Given a table with the following raw data:
|   type   | country | department | year | value |
|----------|---------|------------|------|-------|
| Expenses |   USA   |   Sales    | 2022 |   45  |
| Expenses |   USA   |   Sales    | 2023 |   60  |
| Expenses |   USA   | Marketing  | 2022 |   30  |
| Expenses |   USA   | Marketing  | 2023 |   40  |
| Expenses | Canada  |   Sales    | 2022 |   15  |
| Expenses | Canada  |   Sales    | 2023 |   20  |
| Expenses | Canada  | Marketing  | 2022 |   5   |
| Expenses | Canada  | Marketing  | 2023 |   10  |


1- If we are asked 
rowDimensions: [type,country,department]
columnDimensions: [year] 
the expected output is:

|   type   | country | department/year |  2022  |  2023  |
|----------|---------|-----------------|--------|--------|
| Expenses |   USA   |      Sales      |   45   |   60   |
| Expenses |   USA   |    Marketing    |   30   |   40   |
| Expenses | Canada  |      Sales      |   15   |   20   |
| Expenses | Canada  |    Marketing    |   5    |   10   |


2- if we are asked 
rowDimensions: [type,country]
columnDimensions: [year] 
the expected output is:

|   type   | country/year |  2022  |  2023  |
|----------|--------------|--------|--------|
| Expenses |     USA      |   75   |  100   |
| Expenses |    Canada    |   20   |   30   |

3- if we are asked 
rowDimensions: [type,department]
columnDimensions: [year]
the expected output is:

|   type   | department/year |  2022  |  2023  |
|----------|-----------------|--------|--------|
| Expenses |      Sales      |   60   |   80   |
| Expenses |    Marketing    |   35   |   50   |


4- if we are asked 
rowDimensions: [type,department]
columnDimensions: [year,country] 
the expected output is:

|          |        year        |  2022  |  2023  |  2022  |  2023  |
|   type   | department/country |  USA   |  USA   | Canada | Canada |
|----------|--------------------|--------|--------|--------|--------|
| Expenses |       Sales        |   45   |   60   |   15   |   20   |
| Expenses |     Marketing      |   30   |   40   |   5    |   10   |

Вы рыбачите в лодке в середине озера Байкал. Вы нашли ненужный вам свинцовый грузик на дне лодки и выбросили его в воду. Что произошло с уровнем воды в озере?