I was wondering if there is formula in crystal reports to extract part of a field. Our database has a bill of material with dots for indentation next to the part numbers. i want to get rid of the dots.

 

Level 1 =  .2502650

level 2 =   ..2652560

Level 3 =  ...3505401

Level 4 =  ....5544641

 

What i want is to only extract the part numbers:

2502650

2652560

3505401

5544641

 I want a formula to get rid of the (...) in front of the part numbers. The part numbers could be any digit long. they are not all 7 digits long, so i cant really use the (left, right) function.

 

replace({table.field},".","")

 

Regards,

Ryan.