Forum Discussion

danmcauley's avatar
danmcauley
New Member
9 years ago

Removing text after character or between characters

Hi,   I've imported page from Google Analytics and I only want one specific part from the string. I can write a formula in excel to remove all text after a character ("/") however when using the fo...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi danmcauley,

 

Although many formulas may seem similar to Excel we cannot use them exactly as we do in Excel, I have made this small change to your formula  and it gives the expected result:

 

Column
Split = LEFT( 'Pages'[Page]; 
           SEARCH("/";'Pages'[Page]; 1; 
               LEN('Pages'[Page])-1
             )-1
         )

 

Regards,

MFelix