Normal Topic Formatting in Export (Read 666 times)
magicfish
Member
*
Offline



Posts: 47
Joined: Mar 18th, 2011
Formatting in Export
May 19th, 2011 at 8:16pm
Print Post Print Post  
When exporting in Standard ASCII, Sesame adds .00000000 to integer values.
81502 is exported as 81502.00000000
15 is exported as 15.00000000
etc.

Is there a way to prevent this and have 12345 exported as 12345?
  
Back to top
 
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Formatting in Export
Reply #1 - May 19th, 2011 at 9:52pm
Print Post Print Post  
MagicFish,

I believe the Sesame Export tool will always give you the 'raw data' as it is stored in the database fields. You can change the format the data is stored in by using the 'Property Editor' in SDesigner. (Format Tab>Selected Elements>Custom Format.)

If you want to get fancier with your data during export, you'll want to use sBasic programming (such as in a Mass Update or Command Button) instead of the export tool, or tweak your data after it has been exported with something like Excel.

Steve
  
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Formatting in Export
Reply #2 - May 19th, 2011 at 10:06pm
Print Post Print Post  
Looks like I'm wrong. My suggestion may only change the way the data is displayed in the form.

Hopefully someone will show us both the answer. Smiley

  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Formatting in Export
Reply #3 - May 20th, 2011 at 1:52pm
Print Post Print Post  
Hello,

Sesame export will always export out the Raw un-formatted data.

You can as Steve mentioned use SBasic programming to write out formatted values, or use an HTML report that can be pulled into Excel or Word as a Data source, or if you are needing the data for a Mail Merge in Word you can use the Word Merge Field format switches to format the raw data. Information on Merge Field switches can be found at http://office.microsoft.com/en-us/word-help/numeric-picture-field-switch-HP00518...

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged