Count Spaces - Data Type: Blob

Content

Hi,

I am using the function - length(to_char(answers.solution)) to get the total number of characters in an article but it also includes the spaces and additional spaces from the tables used in the articles which is giving the wrong estimate.

Is there a function to count all these spaces separately so that I can count the exact characters and words in an article?

Regards,

Prat

Version

Service Cloud