Forum Discussion

Sarazin73's avatar
Sarazin73
Frequent Visitor
7 years ago
Solved

Decrypt string values from a column of a table in a query

Hello, i search to decrypt string values from a crypted column on a table imported as a query in my Power BI report. The string is crypted in input with a XOR algorythm as follow : String ToCr...
Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    Hi Sarazin73,

    I've written a custom function for you:

    fnXorCrypt = (
    string as text, 
    xorValue as number
) as text =>
    // concat encrypted characters
    List.Accumulate(
        // get a list of chars
        Text.ToList(string),
        // initial string
        "",
        // accumulate last state and a new encrypted character
        (state, current) =>
            state 
            & 
            Character.FromNumber(
                Number.BitwiseXor(
                    Character.ToNumber(current), 
                    xorValue
                )
            )
    )

    The usage:

    EncodedString = fnXorCrypt("Lundi", 42)

    A test:

     

Nolock's avatar
Nolock
Resident Rockstar
7 years ago

Hi Sarazin73,

I've written a custom function for you:

fnXorCrypt = (
    string as text, 
    xorValue as number
) as text =>
    // concat encrypted characters
    List.Accumulate(
        // get a list of chars
        Text.ToList(string),
        // initial string
        "",
        // accumulate last state and a new encrypted character
        (state, current) =>
            state 
            & 
            Character.FromNumber(
                Number.BitwiseXor(
                    Character.ToNumber(current), 
                    xorValue
                )
            )
    )

The usage:

EncodedString = fnXorCrypt("Lundi", 42)

A test:

 

Sarazin73's avatar
Sarazin73
Frequent Visitor
7 years ago

Hi NoLock,

thanks for your job. It's perfect !