Skip to main content
Question

export format

  • December 16, 2014
  • 2 replies
  • 9 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

 

 

2 replies

fmelizard
Safer
Forum|alt.badge.img+19
  • 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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings