Skip to main content
Question

Converting CSV Char. schema to Date

  • December 3, 2013
  • 2 replies
  • 37 views
ls-vea
Contributor
Forum|alt.badge.img

I have a csv files that I am creating a point shapefile. Currenty, I am only able to create string fields for the shapefile, but I want some of the fields to be dates. How do I convert the csv schema within a workbench to export data fields?

 

 

Thank you
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

takashi
Celebrity
  • takashiCelebrity
  • December 4, 2013
Hi,

 

 

I think you can write a date string formatted in "YYYYmmdd" (e.g. 20131203) into a date type field of the shape file. Consider using the DateFormatter transformer to format the date string.

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
takashi
Celebrity
  • takashiCelebrity
  • December 4, 2013
ah... your question was how to create date type fields on the Shape writer? Open "Feature Type Properties" dialog box of the writer feature type, move to "User Attributes" tab page. You can see Name, Type etc. of the fields; then change Type of required fields to "date".
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,639
Posts
123,885
Replies
41,024
Members
Terms & ConditionsAccessibility statement
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.