Unable to save the Output in Pipe delimated (|)

[Subha]

Let i have a query :-
Select emp_name Employee,
emp_address Address,
emp_data Info,
From Employee emp
Where emp.emp_name like upper('%jos%');

I want to have the output saved to a flat file in the below mentioned format

Employee|Address|Info
qazx|dalas|regular
ueettu|la|contract
uwuw|hawai|permanant

I am unable to find any save as format with the above mentioned one.
Please help

Regards,
Subha

 

[Marco Kalter]

You can only export in CSV, TSV, XML and Excel format.

To obtain a pipeline delimited file, export as TSV and replace all tabs with a pipeline character in Notepad.

 

[Subha]

Hi Marco,
Thanks a lot for your valuable help.
Got to know a new thing
enter a tab... select it an copy... go to edit/replace and paste it on the find box... you will see a wire character like []... notepad/wordpad know it is a tab

Best Regards,
Subha

 

[Harry MacDonald]

As an alternative, you could assemble the data the way you want it in your select statement:

Select Select emp_name||'|'||emp_address||'|'||emp_data as "Employee|Address|Info"
From Employee emp
Where emp.emp_name like upper('%jos%');

Cheers,
Harry