I am working on an XP machine with FME'13 and I have a Address field and I have to find the spaces(middle spaces and not the leading and trailing ) in each and every row.
St._Petters_Road is the valid space(it need not be flagged); but St.__Petters_Road is invalid (as it has two consecutive whitespaces).
It is assumed that the words are correct. But there should not be two two consecutive spaces.
and I need to flag the invalid attributes in a new column as 0 and 1 Can we do that with transformers or in SQL?