Extract Data based on requirements

Question

Need help to get the following result based on a given data:&nbsp;&nbsp;CodeRequired ResultE1SE1E2WE2E3SE3M2E2EE.11EE.22EE.1111M11W11&nbsp;Thanks for your help

fowmy · Accepted Answer

CJ_96601&nbsp;Based on my understanding of the pattern I created a column in Power Query:
if (Text.Start([Code],1) = "E" and Text.Start([Code],2) &lt;&gt; "EE") then "E"&amp;Text.Select([Code],{"0".."9"}) else Text.Select([Code],{"0".."9"})

&nbsp;
&nbsp;

Forum Discussion

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Extract Data from sharepoint

Slicer requirement

Business Requirement Document Template

Data Extraction from Oracle