Idea - Text string manipulation

Text string manipulation

On our Radar

Backend

Expression editor, Build-in Functions, Text

Left(t,length)
right(t,length)

in my opinion, this could be very helpfull in text string manipulation.

It's my first Idea, and I'm not sure it's allready posted or relevant.

08 Mar 2011

Rebecca Hall

The Substr(t, start, length) does this.

08 Mar 2011

Louis Reedijk

Yes, but only from left point of view,

what if I need the right most 6 characters?

example to extract a date from a log file, in the current expression editor I need to do the following:

var Filename = "Daily MaintenancePlan_Subplan_1_20100429022905.txt"

Substr(FileName,(Length(FileName)-18),15)

short version:
left(Right(FileName,18),15)

in my opinion, it would give more flexibility

08 Mar 2011