Forum Discussion

ErisedAlurem's avatar
ErisedAlurem
Frequent Visitor
4 years ago
Solved

Using a custom function in Text.ReplaceValue

I made a post earlier (deleted it because I meneged to solve it myself) about a custom function that I was trying to create to use in Text.ReplaceValue (in the replacer as function argument). From wh...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi ErisedAlurem ,

     

    Please try the code.

     

    = Table.ReplaceValue(#"Changed Type",
    each Text.Split([Base], ";"),
    each Text.Split([Retorno], ";"),
    (x,y,z) => functionTest(x,y,z,0),
    {"Retorno"})

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi ErisedAlurem ,

 

Please try the code.

 

= Table.ReplaceValue(#"Changed Type",
    each Text.Split([Base], ";"),
    each Text.Split([Retorno], ";"),
    (x,y,z) => functionTest(x,y,z,0),
    {"Retorno"})

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.