UPPER CASE

[noodle]

In my list I have records that are inconsistent in being UPPER and
lower case. I usually go in and =UPPER() in my list which works fine
but as my work load gets bigger it would be nice if I could skip this
part and create a string in the ADOR that will change the lower case
to UPPER case. In uPlan I have found the right click menu showing me
options such as UCase(exprAsString) but I am far from any programmer.
Could some one help me in my small plight?

Thanks

Mike

[Tim Perrett]

In the ADOR put the following code:

UCase(|->[name_of_col])

Make sense?

Timothy Perrett

blog: http://blog.getintheloop.eu
lift: http://liftweb.net

[Bill]

Just highlight the exprAsString word (by double-clicking it), then
drag-and-drop the appropriate Field onto it, from the Recipient
Information > Schema tree structure (located at the left of you uPlan
window). You are expected to finally get this: UCase(|->[yourfield]).

Remember that, for each ADOR object, you can check your syntax, by
clicking the sort of gray check button (labeled "expr"), located in
the toolbar, at the top of your uPlan window.

If you would like to check the syntax of the whole plan, just click
the blue check button.

If you would like to be trained at uPlan/uDirect, I guess Xerox in
your country can help.

[Bill]

Tim was faster than I!

:-(

On Feb 3, 8:14 pm, Tim Perrett <he...@timperrett.com> wrote:
> In the ADOR put the following code:
>
> UCase(|->[name_of_col])
>
> Make sense?
>
> Timothy Perrett
>
> blog:http://blog.getintheloop.eu
> lift:http://liftweb.net
>

[noodle]

Thanks I appreciate the help. Training would be nice but I am not
seeing it in the near future so it's going to be a learn as I go.. I
am actually the printer here but when we went through our second
person at this position I thought I would take the opportunity and
learn the process. I have been at it for a few months and adapting
pretty good... I can get the work done anyway... Thanks again for the
help..

Mike

> > > Mike- Hide quoted text -
>
> - Show quoted text -

[Tim Perrett]

That makes a change Bill! usually you reply so fast I can never get
there first :-D

Cheers, Tim

Sent from my iPhone

[Bill]

uPlan is of great value when it comes to handling relational databases
(such as SQL Server, mySQL, Oracle and so), or when your campaign
logic needs some deeper programatic rules, which can be implemented,
simplified or better structured through uPlan variables, uPlan home-
made functions, calls to home-made VBScript or JavaScript. Or when you
need to define filters or sort orders to better process your data
sources. Or when you define a Cross-Media campaign.

If you think that you do ***not*** need all this so far, perhaps you
could not use uPlan, but design your whole campaigns from within
InDesign, in the XMPie uDirect plugin, in an intirely graphical and
menu-driven environment. Once your data source is opened from the
uDirect pane, and once your basic ADORs are automatically created,
just right-click the "Edit Rule" menu, while an ADOR is select.

In this page, you can access both simple (such as "UpperCase"), or
advanced XMPie functions, including 1D and 2D barcodes, Photoshop and
Ilustrator-based uImage personalized images and uChart dynamic charts.

In this page, you can decide to either work with menus, or directly
access the QLingo code (as you could do in uPlan).

If you have some time to self-train a little more, you could retrieve
two comprehensive tutorials, available in the "Download" section at
www.xmpie.com.