Forum Discussion
Combining two Strings
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? 🙂
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 resPlease 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
2 Replies
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 resPlease 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
Awesome. Think I have to learn some M code 🙂 Thank you!
