Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

How to find (desi)litres from notifications

Hi,

 

I have loads of notifications in where has been reported added oil in (desi)litres along with some other text. Here are some examples of the data I have (Notification) and two colums I'd like to have. 

 

NotificationOil addedFor calculation
Added DTE25 0,5l0,5l0,5
Added 0,5l DTE250,5l0,5
5 dl of DTE25 added5dl0,5
0,5 litres of DTE25 added0,5l0,5
5 desilitres of oil added5dl0,5
Added 200 l oil200l200

 

Basically I'd like to search for combination of any amount of numbers (might or might not include comma) with l or dl or litres or desilitres with or without space between the numbers and the text. Is there any way this can be done?

 

-Anssi

0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.