Modifying comparison of string values

• Share
  • Share via Facebook
  • Share via Twitter
  • Share via Linkedin

When comparing string values, various problems can appear. For example, data values can be case-sensitive, and data fields can have leading or trailing spaces. In this case you have to manage the options for text data types correctly to avoid problems in data comparison.

1. In the data options section, you can specify options for the text data types:

   

2. Select Trimming mode from the drop-down list. Here are the options you can specify:

   

   • None — the application will compare all string values without modifications;
   • Leading — the application will trim the leading spaces in all string values before comparison;
   • Trailing — the application will trim the trailing spaces in all string values before comparison;
   • Both — the application will trim both leading and trailing spaces in all string values before comparison.
   • Ignore White Spaces — the application will split string values into tokens by white spaces. Then the application will compare these collections of tokens. Specifying this option may significantly decrease the operation speed.
   • Here are the examples of using different values for the Trimming mode option. Let’s compare the values ”   Information   ” and “Information   “:

     Trimming mode	Value 1	Value 2	Result
     None	"Information"	"Information"	Not equal
     Leading	"Information"	"Information"	Equal
     Trailing	"Information"	"Information"	Not equal
     Both	"Information"	"Information"	Equal

3. Check the Ignore case option to ignore case matching during data comparison operation. If the checkbox is unchecked, the data comparison will be case-sensitive.Here are the examples of using different values for the Ignore case option. Let’s compare the values “Text” and “text”.

   Ignore case	Result
   Unchecked	Not equal
   Checked	Equal

4. Click the Reset button to restore default parameters for all modified options.
5. Please note that the operation properties are stored by the application for the entire project, so all changes to the operation settings that you have made will be automatically used for all objects of the same type in your project.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].