crystal 8.5 left trim

[tomk01]

I need a simple trim statement that will allow me to use the field starting on the 4th character. I.e..
field
1234567890

Intended Output:
567890

 

[synapsevampire]

That's nto a trim function, trim removes spaces in most languages.

Try:

mid({table.field},4)

If you need a specific number of charaters after starting at the 4th, there's an additional optional parameter to the function of:

mid({table.field},4,X)

X is the number of characters.

-k

 

[rosemaryl]

Dear Tomk01,

If this is a string field, this will work nicely,

Mid({Table.Field},4, length({Table.Field}))

If it is a numeric field then

Mid(Totext({Incident.Incident #}),4, length(Totext({Incident.Incident #})))

Regards,
ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[lbass]

You actually show your output starting on the 5th character, so try:

mid({table.string},5)

-LB