Geek asks and answers

Splitting text in FileMaker

This may be a pretty simple question, but I have problems with it. I have some information in a text box that registers a UserID in the form of firstname.lastname. What I need for reporting purposes is to split this data into 2 new fields (created as FirstName and LastName respectively). I tried to replace the contents of the field with a calculation using LeftWords and RightWords, but unfortunately this did not work: LeftWords (Attendance :: UserID; 1) for the first name and RightWords (Attendance :: UserID; 1) for the last name. What this gave me was again UserID. I think that throwing me away is the period separating UserID. Any suggestions? I was looking for several ways to split text, but most of them split text, separated by space ...

+3
source share
1 answer

For the name:

Left ( Attendance::UserID ; Position(Attendance::UserID; "."; 1; 1)-1 )

For last name:

Right( Attendance::UserID; Length(Attendance::UserID) - Position(Attendance::UserID; "."; 1; 1) )
+7
source

More articles:


All Articles