1
 Follower
8
 Likes

Text string manipulation

On our radar
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.
Created on 8 Mar 2011
Comments (2)
8 Mar 2011
The Substr(t, start, length) does this.
8 Mar 2011

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




 

views
223
Followers
1