Removing char "F" from the string 1

[rekhatr10]

Hi everyone,

CR 7.0
datbase sql server 2000
I have a fiedl where ihave to take out the first charcater which happends to be F and display all the other num. How can I do that.

Thank in advance for your help
REkha

 

[vidru]

There are probably many different ways to do it. This should work with CR7:

Right(Trim({Table.Field}),Len(Trim({Table.Field}))-1)

-dave

 

[rekhatr10]

Dave,

I get an error
Right(Trim({Table.Field}),(error)Len(Trim({Table.Field}))-1)
AM I missing something?

Rekha

 

[rekhatr10]

Dave,

The number will be

F23434343

I need to display only 23434343. I did get your formula working but it gives me that string is < 0.


Rekha

 

[MrBillSC]

Rekha,

Use the mid function:
Mid({Table.field},2)

MrBill

 

[vidru]

You must have some records that are blank, or NULL. Try checking the field first:

If (IsNull({Table.Field}) Or {Table.Field} = "") Then ""
Else
Right(Trim({Table.Field}),Len(Trim({Table.Field}))-1)

-dave

 

[synapsevampire]

Try MrBill's solution or just use a replace function:

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

-k

 

[rekhatr10]

Dave

You were right I had null values& the if statmetn took care of that and it worked like a charm.

Thank you so much
Rekha

 

[rekhatr10]

Dave,

in crystal you have to spell length({the file}otherwise it givesan error.

RR

 

[synapsevampire]

RR: Dave's code is correct (he's using Crystal Syntax, not Basic syntax), and the function isn't against a file, it's against a field and requires a terminating parenthesis.

-k