Zonal Word Separation

Zonal Word Separation

Postby » Tue Dec 11, 2007 10:55 am

Lets say I have a zone where there is a Last Name, First Name MI. The Xtrata zone will pick it all up as one field. But I need them to be separate fields.
1. Last name
2. Middle Initial
3. First Name.

My first thought was to make 3 Zonals, but because the names are typed in and vary in length, I didn't think the zonals could be accurate. Is there a way to take one zonal, have it recognize that it contains three words, and break them up into three separate fields?

Martin Bidegaray
Production Manager
Pasadena TX
Posts: 51
Joined: Thu Nov 08, 2007 2:53 pm
Location: Clear Lake, Texas

Postby » Tue Dec 11, 2007 5:11 pm

You'd have to do it in scripting. Recognize the one field, and then break it up in the script to the three different fields.

But that's not quite as easy as it sounds. It's easy enough to find the comma and separate out the first name, but middle initial could get a little tricky. If it's truly only a single initial, that's easy. But some people have multiple middle initials and some may not follow directions and put in the middle name.
Posts: 3374
Joined: Wed May 17, 2006 12:53 pm
Location: USA

Postby » Tue Sep 23, 2008 7:21 am

I've found the easiest way is to create 3 separate fields.
Posts: 41
Joined: Mon Jan 22, 2007 10:18 am
Location: Owensboro, Kentucky

Return to Ascent Xtrata General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest