.* – matches one or more occurrences of any character, including no character.
? – represents or matches a single occurrence of any character.
[ ] – matches any occurrence of character enclosed in the square brackets. It is possible to use different types of characters (alphanumeric characters): numbers, letters, other special characters etc.
Read more about pattern matching in COPY INTO command