The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have loads of notifications in where has been reported added oil in (desi)liters along with some other text such as the oil added. Here are some examples of the data I have (Notification) and two colums I'd like to have (oil added and for calculation).
Notification | Oil added | For calculation |
Added DTE25 0,5l | 0,5l | 0,5 |
Added 0,5l DTE25 | 0,5l | 0,5 |
5 dl of DTE25 added | 5dl | 0,5 |
0,5 liters of DTE25 added | 0,5l | 0,5 |
5 desiliters of oil added | 5dl | 0,5 |
Added 200 l oil | 200l | 200 |
Added SHC PM 220 80 L | 80l | 80 |
Added 600xp320 Mobil 1.5l | 1,5l | 1,5 |
AL8 oil addition 50 litres | 50l | 50 |
78P685 8 desilitres added DTE25 | 8dl | 0,8 |
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
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
7 |