Reformatting a date

Get help with installation and running here.

Moderators: DataMystic Support, Moderators


Reformatting a date

Postby Rusty » Tue Oct 05, 2004 2:29 am

Sorry for the noob question, but we are using datapipe/textpipe to try and reformat a date (in a varcvhar field). It currently is represented as:


And we need to insert hyphens:


What's the simplest method?


User avatar
DataMystic Support
Site Admin
Posts: 2139
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Postby DataMystic Support » Wed Oct 06, 2004 11:52 am

Use an EasyPattern

[ capture(4 digits), capture(2 digits), capture(2 digits) ]

replace with


Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Majestic-12 [Bot] and 1 guest