Skip to main content
Question

export format

  • December 16, 2014
  • 2 replies
  • 40 views

Forum|alt.badge.img
I created a workflow to:

 

1) Connect to ArcSDE (Oracle)

 

2) Read a table

 

3) Export the table data to CSV.

 

 

The data is exported, but the formatting is a problem.

 

 

I have a fields
  • UPRN this is a char/text field with numbers eg: 010000000, or 102000000               Exported as 1.E+11
  • Date fields                                                                                                           Exported as 2.01E+13
Tried chaning output field to text and char in the model.

 

What is the easiest way to sort out the formatting??

 

 

Thanks,

 

 

Clive

 

 
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • December 16, 2014
Have you tried the dateformatter? and the stringformatter (set on s) for the non date attributes?

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • December 17, 2014
StringFormatter.

 

 Or [format] (tcl) in attribute creator