Trimming a Number

[CNeeds]

I have this field that I converted to a number, (ie. 20070508012385) I would like only the first 8 numbers (20070508) to appear...I try Left, Right in my formula which I was unsuccessful due to it being a number. When I try as a String, it put commas with is no good. Thanks for any ideas!!!

 

[RustyAfro]

I think we need more info. What is the original format when it is a string? This looks like a date/time value, why is it a string originally? Have you considered converting the string to a date instead of a number formatting the date to be "yyyymmdd"?

 

[CNeeds]

I know, it's weird...the orginal format has 16 digits that is combined with date & time...I just need suggestions to only get the first 8 digits seperated.

 

[RustyAfro]

Try:

LEFT(CSTR(YourNumber,0), 8)

 

[dgillz]

left(totext({YourField},0,""),8)

or to keep it a number the entire time:

int({YourField}/10000)



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

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[synapsevampire]

Try:

val(left(totext({table.field,0,""),8))

or if you want it to be text, just use:

left(totext({table.field,0,""),8)

-k

 

[synapsevampire]

Ooops, dgillz had it.

-k