Deploy Data Standards Check Tool v1.36_20230505

Distribute data standard inspection tool v1.36_20230505 with an option to select whether to process blank characters as blank characters or as word separators when checking property names. This option can be used when the property name of the logical data model is written in English.

1. Request

KSM made the following request in the comments of the previous post Data Standard Check Tool v1.35_20230321 distribution.

When checking the standard, if the property name (CUSTOMER NUMBER) is combined with only English words, there is a symptom that the standard word combination and standard English matching cannot be checked even if the standard term is registered. I wonder if it has something to do with the logic that treats delimiters as underscores and spaces?
EX)
*Standard words, abbreviations
CUSTOMERS, CUSTOMERS
NUMBER, NO
*Standard term, domain
CUSTOMER NUMBER, NUMBER V10
*Standard domain, data type
NUMBER V10, VARCHAR(10)

In the case of modeling in English, it is difficult to identify words if the property name is attached like a Korean word, so it seems that an option is needed if you need to separate English words with a space.. ^^;;

2. Fixes

As shown in the following image, an option to handle whitespace has been added. (Choose whether to process as a space character or as a word separator)

3. Download Data Standard Check Tool v1.36_20230505

You can download it from the github URL below.

https://github.com/DAToolset/ToolsForDataStandard/raw/main/Property Standard Check Tool_v1.36_20230505_1.xlsm

4. Precautions

The following points require attention.

• There may be bugs in this version.
• I haven't been working on standardization lately, so I can't do a lot of tests, so I'll just do a simple test and distribute it.

If you find any bugs or things that need improvement while using it, please let us know in the comments.