I need help on suppressing the first character in a text field 1

[phil2k]

I have got a field in my report that produces a 7 character code ie. C123456, what I need to know is how to suppress the first character so that I am left with 123456.

 

[synapsevampire]

Create a formula containing:

mid(table.field,2,100)

Replace 100 with the known length of the field, or you can use a large default.

-k

 

[dgillz]

mid({YourField},2) will actually return everything starting with the second character, regardless of length.

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[dgillz]

mid({YourField},2) will actually return everything starting with the second character, regardless of length.

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

Create a formula containing:

mid(table.field,2,100)

Replace 100 with the known length of the field, or you can use a large default.

-k

 

[phil2k]

I found the answer by playing with Excel believe it or not!

The formula is: right({table.field},x)
with x being the number of characters you want to display.

 

[synapsevampire]

Either works, though your example does NOT work without determining what X is first.

You can optionally set the third parameter in my example using MID(), so the equivalent to yours is:

mid({table.field},2)

You don't need to determine what X is since you always want to start at X (2).

-k