Dw_1. SaveAsFormattedText (" D: \ ABC. TXT ", EncodingANSI! '~ ~ ~ ~', ", "' ~ r ~ n, False)
The results are as follows, header line is normal, the data line is always one more ~ symbol,

Goodsname Spc num ~ ~ ~ ~ ~ ~ the Unit price ~ ~ amount
Digititan battery 24 ~ ~ ~ ~ ~ ~ 7 ~ ~ 52.8 ~ 2.2


Seek a solution

CodePudding user response:

It is normal when only a ~ symbol, with two is more than a good end

CodePudding user response:

Why use two, you can change the way of thinking to solve the

Using the describe (" datawindow. Data "), then change ~ t to your delimiter, and then write a file