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