Forum Discussion

Einomi's avatar
Einomi
Icon for Helper V rankHelper V
3 years ago
Solved

Extract Text before "("

Dear Community   I would like a M code to help me identify "(" in my string then extract the text before it   For example, I have the following function in Excel   =REDUCE(A2,CHAR(SEQUENCE(26,,...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi Einomi ,

     

    Try the pbix attached if that is what you are looking for.

    Hope this helps.

     

     

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
3 years ago

hi Einomi ,

 

Are you able to achieve your requirement?

Einomi's avatar
Einomi
Icon for Helper V rankHelper V
3 years ago

Hi mussaenda 

 

I teste with a few formulas, it should work, any issues I'll let you know but for now I will mark this as resolved

 

Thanks for your assistance