How can I export data from a table separated by; instead of,

1

Hello, I am trying to export a table but automatically exporting it as a field terminator ',' and what I would like to follow is that the field separator is ';'. For this I am using a stored procedure.

What I get is:

Part_Number, Tool_Number, ...

1,1, ...

And what I want to achieve is:

Part_Number; Tool_Number; ...

1; 1; ...

Thank you very much. A Greeting Carlos.

    
asked by Carlos Zuazu 05.01.2018 в 07:16
source

1 answer

1
  

In your future questions it would be good if you add the query you make and not put an image.

At the moment of exporting and that the separation of data, it would only be necessary to modify -t, by -t; . For example:

... -U sa -P comanai -c -t; -S DESKTOP-...

Argument:

  

-t field_term

     

Specifies the field terminator. The default value is \ t (tab character).

Reference:

answered by 05.01.2018 / 09:20
source