Forum Discussion

ambi95's avatar
ambi95
Icon for Helper I rankHelper I
3 years ago

Excel formula to power query M code

Hi all, Im trying to convert the following formula in excel to M code : =CONCATENATE(H2, MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ012345",( IFERROR(IF(FIND(MID(H2,1,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ")>0,1,...
General Comment
Need Help
Show and Tell
Tutorial Requests
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

It looks like you are looking for the letters in your initial string. I put your formula into Excel. Can you exlpain how you get DAY suffix from that starting string (that only has two letters in it)?

 

 

Pat

ambi95's avatar
ambi95
Icon for Helper I rankHelper I
3 years ago

Hi ppm1 Apologies, I made a mistake in  my question. The original 15 digit string is a mix of letters and numbers.

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Can you give an example of an input string with the expected output? The one shown isn't clear.

     

    Pat

     

    • ambi95's avatar
      ambi95
      Icon for Helper I rankHelper I
      3 years ago

      ppm1 hi, here is an example of the 15 digit string - 0062o00001CG0Ob

       

      • ambi95's avatar
        ambi95
        Icon for Helper I rankHelper I
        3 years ago

        hi ppm1 do you have any solution or anywhere I can start ?