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+11Date 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

Question

export format

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

Userlevel 4

+13

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

+3

StringFormatter.

Or [format] (tcl) in attribute creator