Forum Discussion

nitskulkarni's avatar
nitskulkarni
Regular Visitor
9 years ago

CSV File Import in Power BI (Pipe | character as delimiter and | within data)

Hi Guys

 

I have a old program running in our db server. The program generated a .csv file which has | character as delimiter and a { as text qualifier. When I try to import the data in Power BI the data gets split as the data itself has a pipe character | and Power BI does not provide any way to specifiy a text qualifier while importing the CSV. Can anyone help me on how I can handle this?

 

Thanks Nitin

1 Reply

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    nitskulkarni ,

    You probably already have this, but ~ in Find will give you the actual character that follows it. Also I might suggest merging the columns. 

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel