Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

CSV file issue

Hi,    I'm trying to import a CSV file that is using commas as separator. But once I import the data, then some rows are separated and some not. If I try it in Excel, then it separates all the rows...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    The problem was with the file. After downloading it from the source system, I didn't open and save it as a csv file anymore, but just took the file from the Downloads folder and now it works. 

Gazzer's avatar
Gazzer
Resolver II
8 years ago

Are you able to take a screenshot of what you see when it fails?

 

I often have CSV files which include carriage returns within fields and these can cause the rows and columns to get a bit messed up. It might be worth checking this first, although I would expect you to have an issue opening in Excel if this were the case. To check/correct this, open the source item and set Line Breaks to "Ignore".

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Gazzer, 

     

    From where can I find the line breaks option, as when I import the file with Text/CSV option, then this is what I get: 

    • Gazzer's avatar
      Gazzer
      Resolver II
      8 years ago

      You have to go back to the Source step after the initial import.

       

      Go to the Applied Steps section on the right-hand side and click the little gear wheel icon next to "Source" to edit the import settings. It should look a bit like the image in my previous post.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Gazzer Unfortunately, it didn't help.