Split a Field in two

[devinh]

I've got an old datbase that has one field that has the customer number and name in one field.

The new database I want them to have thier each field. One for their Number and one for their name.

How should I go about doing this. I thought I should import the data twice. Have every thing in both and then create a script just to delete what I don't need.

The field looks like this now.

123 company_xyz

15 company_dfy

2345 ccompany_xyt

[LaRetta]

Hi Devin,

You can't import part of a field and you're correct in your thinking. I suggest you import into Company Name. Back up first. Then (with your found imported set) put your cursor in the CompanyID field and select Records > Replace Field Contents by calculation and enter:

LeftWords(CompanyName; 1)

Then place your cursor in the CompanyName field and again Replace Field Contents via calculation with:

Trim(Substitute (CompanyName ; LeftWords(CompanyName ; 1) ; ""))

LaRetta

[devinh]

Wow....I never saw that replace field Contents. Here I was trying to make a script.

Thanks, I got something to work and it was simple.

Devin