Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Trouble Removing Invisible Characters

Greetings!    I am having trouble removing invisible characters. I have tried using the clean/trim function + the REPLACE function but the characters are still there. When I check the length of a r...
Need Help
Tutorial Requests
ElenaN's avatar
ElenaN
Resolver V
7 years ago

Hello,

 

Can you maybe use this logic for the len column:

 

LENGTH - WCSR = IF(WCSR[TrackingNumber] = BLANK(), 0, LEN( WCSR[TrackingNumber] ))

Meaning, you can use the comparison of the TrackingNumber column values to Blank() to identify which fields are not completed.

 

If you just want to count the no of blank rows you could try the countblank function.

 

Regards,

ElenaN