Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Split Text Up and Down

  HI , i have no clue how to split the First Text in 1 column and Second Text in another column  for ex : 1 Column : Khan Daun Penh 12200              Another Column : Psar Tmei 3 12210    ...
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Chanleakna123,

 

You can use Split Column by Delimiter feature with line break #(lf). You can test with below Power Query: 

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s5IzFNwSSzNUwhIzctQMDQyMjBQiMkLKE4sUgjJTc1UMAaJGRooxepAFTtnJOZmJxbl5hflAaWMDQxi8kLyS3MUgssSKxUCilIrDcHCFkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}})
in
    #"Changed Type1"

 

 

Reference:

https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/

 

Best Regards,
Qiuyun Yu 

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

 

See the 3 pictures i shared , 

and the other one with the table of the line up and down. 

 

i failed to success your. 

can you please advise more. 

v-qiuyu-msft

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Chanleakna123,

     

    Please replace #(if) as #(lf). 

     

     

    Best Regards,
    Qiuyun Yu 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Chanleakna123,

     

    Is the issue solved? If it is, please mark a helpful reply as an answer. 

     

    Best Regards,
    Qiuyun Yu 

      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        7 years ago

        CASE ID :C-00009319
        HI , what i want is : Cse in 1 column 

        contact in one column 

        Phone in one column 

        Date in one column 

        Agent in one column 

        Due Date in one column 

        Note in on column 

        so every drop down message needs to be in seperated column , 

        i tried for almost 2 hours , still have no idea how to settle this . 

         

        CASE :Product Issue - Quality Complaints > Product - Deviation Product Standard > Carbonation
        CONTACT :Mr. Panna
        PHONE :0965923348
        DATE :1/9/2018 2:46:08 PM
        AGENT :Ms.Vuth Saneth
        DUE DATE :1/10/2018 2:46:08 PM
        NOTE :
        អតិថិជនបានប្រាប់ថាផលិតផល Samuraiរបស់គាត់ចំនួន៣យួរអត់មានហ្គាស(CO2)
        សូមជួយទាក់ទងទៅគាត់ដើម្បីដូរផលិតផលគាត់វិញផង។
        ADDITIONAL INFO :
        - Account ID : N/A
        - Outlet name :Depo D6
        - Caller name and Contact Info : Mr. Seng Heang( 077 790446/ 0965923348 )
        - Location of outlet : # 208, St Kilometer 6, Sangkat Russey Keo, Phnom Penh.
        - Delivery date / Purchase date : Company
        - Purchase from :Company
        - Nature of Complaint : ផលិតផល Samuraiរបស់គាត់ចំនួន៣យួរអត់មានហ្គាស(CO2)
        - Product Name : Samurai
        - Product package size : 480 M.L
        - Quantity : 3 យួរ
        - Date Code : W 17/12/2017, BB 15/5/2018