Excel Data - Left Function

OL Connect Professional
1

I think this may be simple (it is in PP7) but I am not getting the expected answer. I have a field that I want to display only partially.

Example: the field reads “Ad Valorem Taxes”.
I only want to display “Ad Valorem” (characters 1-10)

2

Normally I should redirect you to the PlanetPress Forums, but since this one is simple, here’s the answer:

=left('Ad Valorem Taxes',10)

Of course, the first parameter can be a variable ( =left(&myData,10) ) or a data selection ( =left(field('myField'),10) )

3

In datamapper I would do a javascript extraction and use .substring(0,9) to get only the left 10 chars fo that extraction.
(I understood your comment “it is in PlanetPress” as “it” being simple in PlanetPress but not simple in Connect)

4

Thank you both; the solutions work as intended.