Split a field

[LindaLoo929]

I have data that I need to split. The field is formatted LastName/FirstName Middle Name and I need to break up into 3 different fields. I tried the Split formula, but keep getting errors.

Any thoughts?

 

[fisheromacse]

Maybe not the most elegant, but how about something like this:
Create 4 new formulas:

#1 = {@LastName}
Split({YourTable.YourField},"/")[1];


#2 = {@LenLastName}
len({@LastName}


#3 = {@FirstName}
MID(Split({YourTable.YourField}," ")[1],lenlast+2);

#4 = {@MiddleName}
Split({YourTable.YourField}," ")Ubound(Split({YourTable.YourField}," ")];

 

[LindaLoo929]

All is working perfectly, except for #4. I am getting and error that a ) is missing. I've added and moved around, but still not working.

 

[lbass]

Missing a bracket--should be:

Split({YourTable.YourField}," ")[Ubound(Split({YourTable.YourField}," ")];

You would have to adjust your formulas though if any elements are missing.

-LB