Substring the numbers before the string 1

[saran26]

Hi All,

In my table , the values are stored as numbers followed by a text. Is it possible to display only the text after stripping the numbers before that text.

Example

From
6005466 - 5.1.1 Resting Order is outside Daily Limits

To
Resting Order is outside Daily Limits

Thanks
Saran

 

[lbass]

stringvar x := {table.field};
stringvar z := "";
numbervar i;
numbervar j := len(x);

for i := 1 to j do(
if x = ' ' or
ucase(x) in chr(65) to chr(90) then
z := z + x
);
trim(z)

This would return the text in your example, but if there could be numbers in the text portion of the field, it wouldn't return those.

-LB

 

[saran26]

Thanks.

I will try this

Saran