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

Accepted Solutions (1)

Accepted Solutions (1)

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

Answers (3)

Answers (3)

arijit_das
Active Contributor
0 Kudos

I would suggest you to maintain the short text in master data.

Former Member
0 Kudos

Hi,

If The Patern in your example is same .

=Substr([Product_Description];1;1)+Substr([Product_Description];4;1)+"."+Substr([Product_Description];10;7) + Replace(Right([Product_Description];6);"Prod";"PO")

Former Member
0 Kudos

you can apply alerters on "Product Description".

or you can apply substring to capture common string of your "Product Description" and apply alerters