trim number field 4

[needmoremoney]

I have a field called phonenumber.

(209)234-2343

I need to trim this to just the area code. Any help thanks.

209

I'm using crystal 8.5

 

[bdreed35]

If you always have a leading parenthesis, you can do this in a formula:

{table.field}[2 to 4]

or to be safe, you add the replace function in there:

replace({table.field},"(",""),[1 to 3]

~Brian

 

[BobSuruncle]

Does the field always have round brackets around the area code?
If so, try this

Split( Replace( {Table.Field} , "(" ,""), ")" )[1]


Bob Suruncle

 

[needmoremoney]

Hello Bob, the statement that you gave works great! Thanks much.

By the way, I could you explain to me how it works?

 

[lbass]

Brian's first solution would work and his second one (*)would have worked perfectly, too, but for an extra comma.

replace({table.field},"(","")[1 to 3]

-LB

 

[bdreed35]

Thanks for the backup LB

~Brian