Forum Discussion

alfredorhz's avatar
alfredorhz
Helper I
2 years ago
Solved

Extract text from string

HI Community I have a string, that I get from a PowerShell script, This script creates a report from SharePoint page views, so, in the context of the information the audit data has a very large stri...
Need Help
Show and Tell
Tips and Tricks
  • alfredorhz's avatar
    alfredorhz
    2 years ago

    Thanks guys

    I resolve this with a dax,

    Extract =
    var fin = LEFT(Table[AuditLog], SEARCH("http",Table[AuditLog])-1)
    var Lentf = LEN(fin)
    var Midd = MID(Table[AuditLog], Lentf, 250)
    #This is a delimiter before .aspx or .pdf acces file
    var     http = SEARCH(",", Midd)
    return
    LEFT(Midd, http)
alfredorhz's avatar
alfredorhz
Helper I
2 years ago

Thanks guys

I resolve this with a dax,

Extract =
var fin = LEFT(Table[AuditLog], SEARCH("http",Table[AuditLog])-1)
var Lentf = LEN(fin)
var Midd = MID(Table[AuditLog], Lentf, 250)
#This is a delimiter before .aspx or .pdf acces file
var http = SEARCH(",", Midd)
return
LEFT(Midd, http)