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
    2 years ago

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