Forum Discussion

FredLEGUEN's avatar
FredLEGUEN
Icon for Helper III rankHelper III
6 years ago
Solved

Split text but result align to the right

Hi the group,   I have a list of addresses to split ZA BP63072, 61 Rue de Vitré, 35130 La Guerche-de-Bretagne, France Col du Barioz, 38570 Theys, France 11 Le Hil, 35230 Noyal-Châtillon-s...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi FredLEGUEN ,

    you can use this code:

     

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dVJLbtswEL3KwGvLoKifs7SUOimQukZSZBEnC9aaWgSYIUCRRtwb9BpdpZuuegNdrCPZaaIA3c1i3m/mbTaTuwWU6zwRhZxCHsN1QKgRbrV33a8pJFmcCLhScBHQbRuMaoxKh17tCKewdIq2OHmYbiaVNVAHKJXT9jvj5lkh4EuDh3a0FsdwhXCpTU8tmXplD8pEVdP99NoYS1EbXHSDmrXGwBwWe6SjO8N+lOOFuZBCwLnVtPOj9Sw5JgkgZff8iFDOPs1WswVDEpkPiSqnwggjZfKq0fLKlr2n4uxMwI3S5KO1CiYy3XMbnaunETQf1C6CR/qKbsewNGaVtSW/7aPhO6n8n9KH2gblarhEx5fjEHO+ioBKhbZV9fgGWQblIFQi2e63h6UNjvDgLMGdJYSF87pVpEyfYApVg4+ahoPdByFk0f3witidzIs5a5ycEYZvUR2i66b78+6rA+tHqkPrnUbDvCmslNeW+DTHsrwEKNFo6oMnHPxWcz/C03/bItNsAC/R1ZoU1f3ke2NxzJ04DPxv9k+tPMX47JS3uv9/kcZp//+w5wedivgSuoXSBq6R6/tYpJKJl2rP38E33A9/AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Table.FromRows({List.Reverse(Text.Split([Column1], ","))})),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Column1"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column4", "Column3", "Column2", "Column1"})
    in
    #"Expanded Custom"

     

     

    Enjoy 😉

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi FredLEGUEN ,

you can use this code:

 

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dVJLbtswEL3KwGvLoKifs7SUOimQukZSZBEnC9aaWgSYIUCRRtwb9BpdpZuuegNdrCPZaaIA3c1i3m/mbTaTuwWU6zwRhZxCHsN1QKgRbrV33a8pJFmcCLhScBHQbRuMaoxKh17tCKewdIq2OHmYbiaVNVAHKJXT9jvj5lkh4EuDh3a0FsdwhXCpTU8tmXplD8pEVdP99NoYS1EbXHSDmrXGwBwWe6SjO8N+lOOFuZBCwLnVtPOj9Sw5JgkgZff8iFDOPs1WswVDEpkPiSqnwggjZfKq0fLKlr2n4uxMwI3S5KO1CiYy3XMbnaunETQf1C6CR/qKbsewNGaVtSW/7aPhO6n8n9KH2gblarhEx5fjEHO+ioBKhbZV9fgGWQblIFQi2e63h6UNjvDgLMGdJYSF87pVpEyfYApVg4+ahoPdByFk0f3witidzIs5a5ycEYZvUR2i66b78+6rA+tHqkPrnUbDvCmslNeW+DTHsrwEKNFo6oMnHPxWcz/C03/bItNsAC/R1ZoU1f3ke2NxzJ04DPxv9k+tPMX47JS3uv9/kcZp//+w5wedivgSuoXSBq6R6/tYpJKJl2rP38E33A9/AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Table.FromRows({List.Reverse(Text.Split([Column1], ","))})),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Column1"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column4", "Column3", "Column2", "Column1"})
    in
    #"Expanded Custom"

 

 

Enjoy 😉