String capturing, splicing, and pivot tables in Excel

Assume that the table is as follows:

How to obtain the data of column E (in the format of Schema name. Table name, such as pdm_data.t05_gms_nav_spv_pch_rdm_trx_evt )? How does one obtain column F Data from column E (extract the table name from Class E )?

1. String concatenation

In column E, enter: = C3 & "." & D3

2. String Truncation

First, we will introduce several functions:

LeftFunction,RightFunctions andMidFunction

Left function Syntax: Left (text, num_chars), part of the string from the left

Right function Syntax: Right (text, num_chars), part of the string from the right

Text indicates the string to be truncated, and num_chars indicates the number of characters to be truncated.

Mid function Syntax: Mid (text, start_num, num_chars), part of the string starting from a certain position in the middle

Text indicates the string to be truncated, start_num indicates the number of characters to be truncated, and num_chars indicates the number of characters to be truncated.

Here we select the mid function for string truncation:

3. Pivot table

The so-called pivot table is actually a statistical table. Let's talk about it later ~

String capturing, splicing, and pivot tables in Excel