Home » Developer & Programmer » Forms » Export data with format mask (Forms 6 and Forms 10.1, WinNT)
Export data with format mask [message #405002] Tue, 26 May 2009 00:56 Go to next message
DirkHamburg
Messages: 5
Registered: May 2009
Location: Hamburg
Junior Member
Hello!

I want to export data from forms to a csv-file (via TEXT_IO).
My problem: The data should be exported using the format mask as in the item properties of the form declared.

E.g. the value 123456789012 with the according format mask
9999" "9999" "9999
should be exported as 1234 5678 9012.

As there are a lot of items with different format masks, it cannot be solved with manually redesigning the format mask like
substr(field_val,1,4) || ' ' || substr(field_val,5,4) || ' ' || substr(field_val,9,4)


I fetch the needed format mask with
var_fm := get_item_property(field, format_mask); 


Do you know a way to get the field content "connected" with the format mask?

Thank you for your help!

Best regards,
Dirk
Re: Export data with format mask [message #406270 is a reply to message #405002] Wed, 03 June 2009 01:31 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you tried doing a 'to_char' using the retrieved format?

David
Previous Topic: Sending mail from form (split from Text Moving on the Form)
Next Topic: Problem With Progress Bar And Check Boxex
Goto Forum:
  


Current Time: Sun Nov 03 07:59:10 CST 2024