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: Surges Bay TAS 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: Fri Aug 18 07:52:01 CDT 2017

Total time taken to generate the page: 0.12541 seconds