Using Leftword and the # character

#1

I have a text field wiht mutiple words in it. The text field might be
"12345678" or "123456789" or "1234567890" followed by a varying number
of spaces followed by the - character followed by 1 or more words.

I used the leftword command to separate the first word and it works
fine, except when the first word contains a "#" character, i.e.,
"12345678#AGM".

In this case it thinks the first word is "12345678" and not "12345678#AGM".

How do I get FIlemaker 11 to recognize the # as part of the first word.

TIA

#2

Bubba <bubba (AT) mail (DOT) net> wrote:

Quote:

I used the leftword command to separate the first word and it works
fine, except when the first word contains a "#" character, i.e.,
"12345678#AGM".

In this case it thinks the first word is "12345678" and not "12345678#AGM".

Most punctuation marks act as word separators in Filemaker.
(Exceptions that I know of are the apostrophe (single quote) and the
period.)
So Leftwords(Substitute(text; "#"; ""); 1) should do the trick.

--
Hans Rijnbout
Utrecht, Netherlands

#3

Hans Rijnbout <jrijnb (AT) xs4all (DOT) nl> wrote:

Quote:

Bubba <bubba (AT) mail (DOT) net> wrote:

I used the leftword command to separate the first word and it works
fine, except when the first word contains a "#" character, i.e.,
"12345678#AGM".

In this case it thinks the first word is "12345678" and not "12345678#AGM".

Most punctuation marks act as word separators in Filemaker.
(Exceptions that I know of are the apostrophe (single quote) and the
period.)
So Leftwords(Substitute(text; "#"; ""); 1) should do the trick.

That was too quick. You would want to put the # back again, so you
replace it with something unique and replace back:
Substitute(Leftwords(Substitute(text; "#"; "'"); 1); "'"; "#")
where "'" is a quoted single quote.

--
Hans Rijnbout
Utrecht, Netherlands

#4

In article <1k2oe0v.b1qh1lmhp0d6N%jrijnb (AT) xs4all (DOT) nl>, jrijnb (AT) xs4all (DOT) nl
(Hans Rijnbout) wrote:

Quote:

Bubba <bubba (AT) mail (DOT) net> wrote:

I have a text field wiht mutiple words in it. The text field might
be "12345678" or "123456789" or "1234567890" followed by a varying
number of spaces followed by the - character followed by 1 or more
words.

I used the leftword command to separate the first word and it works
fine, except when the first word contains a "#" character, i.e.,
"12345678#AGM".

In this case it thinks the first word is "12345678" and not
"12345678#AGM".

Most punctuation marks act as word separators in Filemaker.
(Exceptions that I know of are the apostrophe (single quote) and the
period.)

So Leftwords(Substitute(text; "#"; ""); 1) should do the trick.

Since the wanted text is always follwed by a space (it doesn't matter that
the number of them varies), then another way would be to simply take all
the characters up to, but excluding, the first space.
i.e.
Left (TextField; Position (TextField; " "; 1; 1) - 1)

I don't know if the Left / Position combination calculates any faster than
LeftWords / Substitute combination.

Helpful Harry

)

#5

On 2011-06-10 17:52:54 -0700, Your Name said:

Quote:

I have a text field wiht mutiple words in it. The text field might
be "12345678" or "123456789" or "1234567890" followed by a varying
number of spaces followed by the - character followed by 1 or more
words.

I used the leftword command to separate the first word and it works
fine, except when the first word contains a "#" character, i.e.,
"12345678#AGM".

In this case it thinks the first word is "12345678" and not
"12345678#AGM".

Most punctuation marks act as word separators in Filemaker.
(Exceptions that I know of are the apostrophe (single quote) and the
period.)

So Leftwords(Substitute(text; "#"; ""); 1) should do the trick.

Since the wanted text is always follwed by a space (it doesn't matter that
the number of them varies), then another way would be to simply take all
the characters up to, but excluding, the first space.
i.e.
Left (TextField; Position (TextField; " "; 1; 1) - 1)

I don't know if the Left / Position combination calculates any faster than
LeftWords / Substitute combination.

Helpful Harry

)

Thanks to both of you for the suggestion.

#6

On 2011-06-10 17:52:54 -0700, Your Name said:

Quote:

I have a text field wiht mutiple words in it. The text field might
be "12345678" or "123456789" or "1234567890" followed by a varying
number of spaces followed by the - character followed by 1 or more
words.

I used the leftword command to separate the first word and it works
fine, except when the first word contains a "#" character, i.e.,
"12345678#AGM".

In this case it thinks the first word is "12345678" and not
"12345678#AGM".

Most punctuation marks act as word separators in Filemaker.
(Exceptions that I know of are the apostrophe (single quote) and the
period.)

So Leftwords(Substitute(text; "#"; ""); 1) should do the trick.

Since the wanted text is always follwed by a space (it doesn't matter that
the number of them varies), then another way would be to simply take all
the characters up to, but excluding, the first space.
i.e.
Left (TextField; Position (TextField; " "; 1; 1) - 1)

I don't know if the Left / Position combination calculates any faster than
LeftWords / Substitute combination.

Helpful Harry

)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using Leftword and the # character

comp.databases.filemaker comp.databases.filemaker

Using Leftword and the # character - 06-10-2011 , 05:18 PM

Re: Using Leftword and the # character - 06-10-2011 , 07:21 PM

Re: Using Leftword and the # character - 06-10-2011 , 07:34 PM

Re: Using Leftword and the # character - 06-10-2011 , 07:52 PM

Re: Using Leftword and the # character - 06-19-2011 , 03:22 PM

Re: Using Leftword and the # character - 06-19-2011 , 03:22 PM