cancel
Showing results for 
Search instead for 
Did you mean: 

webi report short names BOXIR 3.1

Former Member
0 Kudos

Hello all,

I have a webi report with column  "Product Description". This column has around 1000 rows and the data is in the format: CarSale.prod01

AccSale.prod02; CarWash.prod03; CarWash. Convert PROD05 and so on.

I want that this column displays short form of the names. Like for CarSale.prod01 it displays CS.PO01 and same way AS.PO02, CW.PO03, CW Convert PO05 and so on. How can I achieve this in the report or universe? I have around 1000 rows with different names.

Thanks,

N

View Entire Topic
former_member182342
Active Contributor
0 Kudos

Hi Nisha,

Check below formula

=Substr([Prodcut Description];1;1)+Substr([Prodcut Description];4;1)+".PD"+Right([Prodcut Description];2)

Regards,

Anish