Search for a specified text and extract specified No. of characters from that text in Power BI

[erp]

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.

Thanks....

[tex628 · Accepted solution]

Hi, 

Try this:

Text.Range( [Column] , Text.PositionOf( [Column] , "VER" ) , 6 )

Br, 
J

[erp]

Thanks... It Worked