How to use |~ together in Custom Delimiter in SSMS ?

Question

I have to specify two custom delimiter in SSMS to retrieve results in a file '|~'. Custom delimiter in SSMS accepts only one character. How can I achieve this ? I have access only to SSMS on machine.

Thanks In advance!

Answer 1

Not clear how you try to import the file using SSMS?
Do you mean the Import/Export wizard? That one accepts more then one delimiter sign, just enter them instead selecting a predefined delimiter.

Olaf

Answer 2

Hi,

As Olaf said, If you are using the Import/Export wizard to import results in a file into a SQL Server table (Or export from SQL Server to file), you can manually enter the'|~' In the column delimiter selection box.Then click Refresh to check the results. As follows:

===============================================

If the response helped, do "Accept Answer" and upvote it.