Trim help...

[omacron]

Hi

I am trying to do a simple Trim command but have some problems. Here is a sample data;

XXXX123456YYYYYYYYY

note: XXXX is a constant
YYYYYYYYY is a constant

What I need to do is strip out the X's and Y's so only the numbers appear. This is what I am doing right now;

if InStr ({Table.Field}, "XXXX") <> 0 then
    Trim(Mid({Table.Field}, InStr ({Table.Field}, "XXXX") + 4))
else 
  Trim({Table.Field})

This gives me this; 123456YYYYYYYYY

I am not sure how to remove the Y's as well.

thanks

 

[dgillz]

Will the Xs always be 4 characters and the Ys always 9 characters? Will the number in the middle always be 6 characters?

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[omacron]

Yes to all of those.

 

[jdemmi]

mid("XXXX123456YYYYYYYYY" [-10 to 1],5)

-- Jason
"It's Just Ones and Zeros

 

[omacron]

oh Sorry, miss understood your question; the 123456 will be changing. Unless I am very wrong that will not work or I don't understand mid (wouldn't be surprised either way).

 

[jdemmi]

Mine will (SHOULD)

mine remove the 9 Y's and then removes the 4 X's

-- Jason
"It's Just Ones and Zeros

 

[dgillz]

But will the middle part always be 6 characters? If so use:

Mid({YourField},5,6)

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[omacron]

That works perfectly thanks