What is the function to count number of spaces in a cell.

623 Views

Hi Experts,

In Webi, i am stuck with one scenario. The scenario is I have a column named Customer Address. In that i want to know how many "spaces" are there for the each row.

I have created variable and tried using various functions like Count, Substr etc... but those are not appropriate for this scenario. Please Help me.

Customer Address 1400 RamNivas Opp.Croma Circle6 Gurgon 11-88 KPHB Opp.BrandFactory Hyd 1-4-8 ChitrangColony Vijayanthi Chennai

I want output like Below,

Address has to display till second space or till third space or till fourth space........

based on the client decision i will select the address length.