I need to clean one column so the Qlik Sense so it shows only valid data
Hi my friends
In my table i have one field called PLACA, this field have a format of character and should be filled as follows: AAA0123 (it´s just one exemplo)
However some users fill with garbage, "aaaaaaa", "/ \ / \", "! @ # $%" and others ... I need to apply to this column in Qlik Sense a function that initially only displays fields that contain 7 characters.