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.