Combining two Strings

[ChrisSv]

Hi.

I am trying to combine two strings with Power Query.

I have string A: "A;B;C;D" and String B: "1;2;3;4".

String A and B do allways have the same number of semicolon.

I want to combine the two strings to a string C looking like this: "A-1;B-2;C-3;D-4".

This is just an example, but the most important is to be able to put "-" and ";" in between the values in string C.

Can someone help me with a script? 🙂 

[AlB · Accepted solution]

Hi @ChrisSv 

Place the following M code in a blank query to see the steps.

let
    StringA = "A;B;C;D",
    StringB = "1;2;3;4",
    listA = Text.Split(StringA, ";"),
    listB = Text.Split(StringB, ";"),
    res = Text.Combine(List.Transform(List.Zip({listA, listB}), each Text.Combine(_,"-")),";")
in
    res

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[ChrisSv]

Awesome. Think I have to learn some M code 🙂 Thank you!