export pipe delimitted

[Walter Vaughan]

scooter6 at gmail.com wrote:

> Client wants some select records sent to them using pipe delim format.
>  
> I think I'm fairly close on the output processing, but it's all hard 
> coded.
> I want to make this where the user select the records by entering a 
> client number or a range of client numbers.
>  
> This calls for a second output processing?

Yes

>  
> So, eventually I can put this on a menu that would call something like
>  
> /u/appl/fp/rreport file -f export -u -a -v clientsel
>  
> In clientsel, I need to put what exactly that would ask the user for a 
> beginning client number and ending client number?

Yes

>  
> Also, is it customary in a pipe delim file to have a pipe at the end 
> of the record?
>  
> So, should it look like:
>  
> John|Smith|1234|field1|field2|
>  
> or just:
>  
> John|Smith|1234|field1|field2    ??

Depends upon what's sucking the data in. I  seem to remember having a 
problem with PostgreSQL vs MySQL
with trailing pipe requirements. If they are bringing it into Excel, it 
could care less.
You gotta find out what's reading the data in.
Kinda why XML is used for data import, no ambiguity.

--
Walter