I have a Column with some description like 1024D 32A DL WO MODEM VER1.2 99/2006-24V
I need to Search for text VER, if it is found then need to extract VER1.2 as my column.
Please help me out.
Go to Solution.
Hi, Try this:
Text.Range( [Column] , Text.PositionOf( [Column] , "VER" ) , 6 )
View solution in original post
Thanks... It Worked
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!