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
Messages: 5
Registered: May 2009
Location: Hamburg
Junior Member

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,
Re: Export data with format mask [message #406270 is a reply to message #405002] Wed, 03 June 2009 01:31 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you tried doing a 'to_char' using the retrieved format?

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: Tue Oct 25 03:48:21 CDT 2016

Total time taken to generate the page: 0.07766 seconds