How to extract the year using the “in” function in Access?

You can use the ‘in’ function to extract the year. The specific steps are as follows:

1. Assign the string of the year to a variable, such as ‘year’.
2. Use the in function to determine if a specific year format is included in the string. For example, you can check for the format “xxxx年”, where xxxx represents a four-digit year.
3. Return True if a specific format of year exists in the string, otherwise return False.

Here is a sample code:

year = "2022年"
if "年" in year:
    start_index = year.index("年") - 4
    extracted_year = year[start_index:start_index+4]
    print(extracted_year)  # 输出：2022
else:
    print("未找到年份")

In this example, assuming the format of the string contains the character “年”, you can use the in function to check and the index function to find the start index of the year. Then, extract the year using slicing. The output result is 2022.