Forum Discussion

ChristopheFr's avatar
ChristopheFr
New Contributor II
2 years ago
Solved

Delete some characters from header before bulk load

Hello, I would like to delete/replace some characters (typically .) from headers in xlsx or csv file before loading the file in SQL Server using bulk load. Does someone has any idea ? Thanks.
  • ChristopheFr's avatar
    ChristopheFr
    2 years ago

    Mapper with :
    $.mapKeys((value,key) => key.replace("'",""))
    before bulk load solve the problem.

koryknick's avatar
koryknick
Employee
2 years ago

ChristopheFr - Welcome to the Community!

You can read the file using a File Reader and CSV or Excel Parser, then use a Mapper or Structure snap to rename the columns, then use the SQL Server Bulk Load snap to push the data into the database.