Moving a topic: Exporting to data file

[graz]

Continuing the discussion from Welcome to the Microsoft SQL Server Forums at SQLTeam.com:

@wishtolearn

Dear Sir,
I need to get output in text file from mssql

This is the format which I have raised from website of ICEGATE EDI format
ICEGATE Header:
HREC^]ZZ^]^]ZZ^]^]^]^] ^]^]^]^]
Example:
HREC^]ZZ^]ABCD^]ZZ^]XYZ^]ICES1_5^]P^]^]COCHE01^]123456^]20071015^]1015

Pont 1 : When I open the Output in Notepad I get in this manner without any spaces in between
--------------------------------------------------Point 1------------------------------
HRECZZAAACF2188HZZINNSA1ICES1_5TSACHI011201512080959

---

Point 2 : When I open the Output in Word pad I get in this manner with spaces in between
--------------------------------------------------Point 2------------------------------
HREC ZZ AAACF2188H ZZ INNSA1 ICES1_5 T SACHI01 1 20151208 0959

Point 3 : When I open the Output in Notepad++ I get in this manner with GS where space shown ie Group Separater

How can I handle this via syntax in MSSQL

[JeffModen]

I guess my question would be, "What spaces"? Is ^] some sort of magical syntax that's supposed to represent a space? Also, what "output"? Is it coming from SSMS or a file or ???

Apologies... someone else may know a solution for this but there's not enough information here for me to even hazard a guess.