talendmultiplicationdivisiontmapdata-integration

How to check column that contain letter and number in Talend

My columns must contains 2 letter and 4 number like this (AV1234)

How can i check this ?

Solution

  • You can use sql templates as mentioned in talend documentation here and you can check your column that contain letter and number using regular expressions.

    Use this [a-zA-Z]{2}[0-9]{6}

    Use this If you want only uppercase letters [A-Z]{2}[0-9]{6}

    [a-zA-Z]    # Match a single character present in the list below
            # A character in the range between “a” and “z”
            # A character in the range between “A” and “Z”
  {2}       # Exactly 2 times
[0-9]       # Match a single character in the range between “0” and “9”
  {6}       # Exactly 6 times