Forum Discussion

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.

rashmi

New Contributor III

3 years ago

Hi @naveen pls could u share the pipeline pls how it was achieved

darshthakkar

Valued Contributor

3 years ago

@rashmi: There’s a snap known as XML generator where you can define your XSD and with the help of file writer you can generate xml files. Just remember to add an extension “.xml” to the file writer to achieve desired results.

Forum Discussion

Delete some characters from header before bulk load

Related Content

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?