Skip to main content
  • EN
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

 

 
Have you tried the dateformatter? and the stringformatter (set on s) for the non date attributes?
StringFormatter.

 

 Or rformat] (tcl) in attribute creator

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.