Greetings!

I have a question

First - Sorry if this is the wrong section - seems to fit better here than anywhere else...

Anyhow! I have a record set of about 200,000. The main field has a chunk of text in it. Would it be possible to somehow generate 2 new versions of those fields - each with punctuation added at the beggining and end of them? Note: it would be the same punctuation for all fields though...

Example:

Field: The brown cow goes moo

I want to get:

"The brown cow goes moo"

and

!The brown cow goes moo!

Create two new fields and call what you want. For this example, I used YourTextFieldHere Make the calculations as follow with a text result.

Try

""" & YourTextFieldHere & """

and

"!" & YourTextFieldHere & "!"

HTH

Lee

Edit = Lee answered a chunk And I figured out the rest :P

Edited July 28, 200520 yr by Guest

Thanks Lee! That """ worked great for the quotes What does that represent? Love knowing the hows and whys behind things :D

New in version 7, is some Regular Expression abilities, including escaping operators. In this case, it's just telling FileMaker to "Escape the " following the , meaning that it is to be considered text now.

Lee