View Single Post
  #1   Report Post  
Jeff Perreault
 
Posts: n/a
Default how do I create a data entry edit mask?

I've been tasked with saving excel data as a .csv, then uploading the data
into an ingres database. There are numerous needs for special formatting in
the ingres database, and I'm trying to devise methods to deal with some of
them...

- a numeric field required a blank at the end of it (12345b)
- blank values in the cells that need to be converted either to null or to
-1E38
- 15 character numbers that need to stay as discrete numbers, not go to sci.
not.

Many of these seem like they could be resolved with some edit masks, but I
can't locate any decent coverage of the topic in the online help. Am I not
looking in the right place? Or is there a separate source for documentation
that I should be using?

Jeff