Including "()" i.e. brackets when using the Leftword or Rightword text function.

[Vincent Koh]

Hi there, I have a field call CompanyName. When user enter data into this field, I have script that breaks the data into 4 variables. So for e.g., the user key in Bank Of America , so I have 4 var $Name1=Bank, $Name2=Of, $Name3=America and $Name4="".

The problem is when the input is something like "Bank of America (NY)" and using what I did above I get $Name1=Bank, $Name2=Of, $Name3=America and $Name4=NY.

The last var is puzzling because what I wanted was to also include the brackets i.e.. $Name4= (NY) instead of just "NY"

Hope someone can show me how I can achieve this.

Thank you so much.

[comment]

I have script that breaks the data into 4 variables.

For what purpose?

[Raybaudi]

what I wanted was to also include the brackets

Do not use those functions but use GetValue ( ) instead.

Something like ( for the forth data ):

Let(

values = Substitute ( CompanyName ; " " ; ¶ );

GetValue ( values ; 4 )

)

[comment]

The xWords functions recognize all word delimiters, not just space.