export pipe delimitted

[Scott Walker]

From:
filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.
com] On Behalf Of scooter6 at gmail.com
Sent: Tuesday, January 20, 2009 11:10 PM
To: filePro Mailing List
Subject: export pipe delimitted

 

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? 

 

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?

 

 

The "second output processing" is called Sort/Select processing in fp.  As
you said above, it's called on the command line with "-v"

 

Try something like this:

 

Say Client Number is field #1

 

If:            bc eq ""

Then:    input bc(5,*,g)"Enter Begin Client Number: "

 

If:            ec eq ""

Then:    input ec(5,*,g)"Enter End Client Number: "

 

If:            1 gt bc and 1 lt ec

Then:    select

 

If:

Then:    end        

 

 

 

 

 

 

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    ??

 

thanks in advance for any guidance

 

Scott

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090121/ab09156d/attachment.html