Forum Discussion

massotebernoull's avatar
massotebernoull
Icon for Helper I rankHelper I
4 years ago
Solved

Replace multiple words in a row

Hello, I'm struggled with this replacement:   I have this table: Original TRY1 TRY2   Non-qualified Non-qualified   Non-qualified Non-qualified   Non-qualified Non-qualified ...
Need Help
Show and Tell
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Ah, I think the issue must be earlier then.

     

    Try putting the null check in earlier:

    Text.Combine(
    List.Transform(
        Text.Split(if [Original] = null then "" else [Original], ","),
            each
                if      _ = "100000011" then "Declared bankruptcy"
                else if _ = "100000014" then "Filantropic school"
                else if _ = ""          then "non-qualified"
                 else "Verify"
        ),
        ","
    )
)
massotebernoull's avatar
massotebernoull
Icon for Helper I rankHelper I
4 years ago

It didn't work either

It shows

"Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]"

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Ah, I think the issue must be earlier then.

 

Try putting the null check in earlier:

Text.Combine(
    List.Transform(
        Text.Split(if [Original] = null then "" else [Original], ","),
            each
                if      _ = "100000011" then "Declared bankruptcy"
                else if _ = "100000014" then "Filantropic school"
                else if _ = ""          then "non-qualified"
                 else "Verify"
        ),
        ","
    )
)
  • massotebernoull's avatar
    massotebernoull
    Icon for Helper I rankHelper I
    4 years ago

    This one works very well. Thank you!