seperating names

Discuss DataPipe. Get help with installation and running it, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Wed Aug 27, 2003 3:01 am

seperating names

Post by nixonron » Wed Aug 27, 2003 3:04 am

I have a database filed with names from a court docket with name like
Nixon Ron v. Dole, Robert. I want to seperate the two into seperate fields. Can you do this with datapipe. Or can I use TextPipe to do the job?


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

Post by DataMystic Support » Fri Oct 03, 2003 5:29 am

Hi Ron,

The first step is to create a copy of the database column - one for the left name, one for the right name. Then write two TextPipe filters for DataPipe - one to retain the left name, and one to retain the right name (before and after the ' v ' respectively).

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

Posts: 18
Joined: Tue Sep 23, 2003 3:13 am

SQL could do it as well....

Post by jring » Fri Mar 12, 2004 5:04 pm

I'm an absolute avid fan of TEXTPIPE and Datapipe, however, this particular challenge, I'd attack with SQL:

LTRIM(RTRIM(Left(Column_X, (Charindex('v.', Column_X))) as NIXON_RON,
LTRIM(RTRIM(Right(Column_X, Len(Column_X) - Charindex(' v. ', Column_x)))) as DOLE_ROBERT
From Table_Full_o_Data

Post Reply