In a string 1

[NipperP]

Hi

I have a varchar field which holds 3 codes

ON WCC4000

ON relates to the type of invoice
WCC relates to the batch number
4000 relates to the centre number

I am interested in getting the centre numbers out. The centre numbers and all the other numbers vary in length!!

Does anybody know of a formula which can take the last n amount of digits to the right. Not knowing how many digits there are!!

Hope this makes sense.

Thanks

Daniel

 

[mbarron]

Wow - Has anyone seen my Crystal Ball?

You need to supply more information. At the very least some sample data with expected output.

Is there any consistancy at all to the data?


Mike

 

[lbass]

The following assumes that numbers are only found on the right end of the string:

numbervar i := 0;
numbervar j := len({table.string});
numbervar k := 0;
stringvar array result := "";

for i := 1 to j do(
if isnumeric({table.string}) then
(redim preserve result;
k := k + 1;
result[k] := mid({table.string},i)));
result[1];

-LB

 

[NipperP]

lbass thanks that works a treat your a *.
Mbarron thanks for your input but no Crystal ball required!

 

[dgillz]

If lbass is a * you should give him one. In fact I'll do it for you.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz