Forum Discussion

wi11iamr's avatar
wi11iamr
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Replace carriage return in dataset

Hi there,   I have some columns in my dataset that has a large amount of text that includes a carriage return for some records.   Does anyone know of some interesting techniques I could try to re...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    wi11iamr It would appear you can do this in the Desktop.

    In the Data section, click "Edit Queries" in the ribbon.

    Select the table you want, and right click the column header

    Select "Replace Values", click in the "Value To Find"

    Select "Advanced Options" check "Replace using special characters"

    Select "Insert special character"

    Click "Carriage Return" and a carriage return should show in your values section

    put comma in "Replace With"

    OK

    Close and Apply

     

    This is "in theory" as I didn't directly test it, but the sequence appears to support the action.

aggregator3000's avatar
aggregator3000
Icon for Advocate II rankAdvocate II
3 years ago

Bumping this old one for anyone wanting to do this in DAX.
Note, Line feed and Carriage Return are different to eachother.
I only know this after dealing with a string that had both... yep


You can use either of following, or combine them

 

Substitute out the carriage = 
    SUBSTITUTE( [TestCarriage],
                unichar(13),
                "\") --Replacement here

Substitute out the Line Feed = 
    SUBSTITUTE( [TestLineFeed],
                unichar(10),
                "\") --Replacement here