Forum Discussion

ITMSPMAN's avatar
ITMSPMAN
New Member
6 years ago
Solved

Removing SEP=, from CSV files

I am using the Get Data > Folder function to combine a heap of CSV files in a folder.

 

All of the CSV files are structured the same but they start with a SEP=,  on the first line, then the headings on the second line.

 

Is there a way I can Strip the SEP=, from the CSVs during the import some way?

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi ITMSPMAN ,

     

    Transform data in "Transform Sample File": Remove top 1 row -> Use first row as headers.

     

    Then, delete the "Changed Type" step in the combined query and then change data type manually.

     

    One video for reference.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi ITMSPMAN,

     

    When you do a transformation from folder it creates a custom function that will treat all the files in the same way. 

     

    Go to the example file and remove the query line that promote the first line to headers.

     

    Then remove the 1st line and do the promote 1st line to headers.

     

     

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi ITMSPMAN ,

     

    Transform data in "Transform Sample File": Remove top 1 row -> Use first row as headers.

     

    Then, delete the "Changed Type" step in the combined query and then change data type manually.

     

    One video for reference.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.