o 5ti @sUdZddlZddlmZddlmZddlmZmZddl m Z dZ ee d <d Z ee d <ed ee d dejZee d<deddfddZddededefddZdS)zA .. codeauthor:: Tsuyoshi Hombashi N)Final)validate_pathtype) ErrorReasonValidationError) _preprocess__MAX_SHEET_NAME_LENz[]:*?/\__INVALID_EXCEL_CHARS[s]__RE_INVALID_EXCEL_SHEET_NAME sheet_namereturncCsjt|t|tkrtdtt|tjdt|}t |}|dur3tdt | tj ddS)ah :param str sheet_name: Excel sheet name to validate. :raises pathvalidate.ValidationError (ErrorReason.INVALID_CHARACTER): If the ``sheet_name`` includes invalid char(s): |invalid_excel_sheet_chars|. :raises pathvalidate.ValidationError (ErrorReason.INVALID_LENGTH): If the ``sheet_name`` is longer than 31 characters. z3sheet name is too long: expected<={:d}, actual={:d}) descriptionreasonNz,invalid char found in the sheet name: '{:s}')rlenr rformatrINVALID_LENGTHrrsearchreescapegroupINVALID_CHARACTER)runicode_sheet_namematchrR/home/ubuntu/.local/lib/python3.10/site-packages/pytablewriter/sanitizer/_excel.pyvalidate_excel_sheet_names$   rreplacement_textc CsFzt|}Wnty}zt|d}~wwt||}|dtS)aE Replace invalid characters for an Excel sheet name within the ``sheet_name`` with the ``replacement_text``. Invalid characters are as follows: |invalid_excel_sheet_chars|. The ``sheet_name`` truncate to 31 characters (max sheet name length of Excel) from the head, if the length of the name is exceed 31 characters. :param str sheet_name: Excel sheet name to sanitize. :param str replacement_text: Replacement text. :return: A replacement string. :rtype: str :raises ValueError: If the ``sheet_name`` is an invalid sheet name. N)rAttributeError ValueErrorrsubr )rr!remodify_sheet_namerrrsanitize_excel_sheet_name6s   r')r )__doc__rtypingr pathvalidaterpathvalidate.errorrr_baserr __annotations__r compilerUNICODErstrrr'rrrrs