Passing a second parameter to LTRIM

[benshsms]

Essentially I want to write the SQL function

LTRIM (JOBTITLE, '-')

to remove anything before the hypen from the text field job title. however crystal's version of LTRIM wont allow me to pass the second parameter ('-'),or any other second parameter, into the function. Does anyone know of a formula that can be used as a work around to this problem

Cheers!

 

[hilfy]

Try this:

If Instr(JOBTITLE, '-') > 0 then
  Mid(JOBTITLE, (Instr(JOBTITLE, '-') + 1)
else
  JOBTITLE

-D

 

[benshsms]

Thanks it works superbly...is there any similar code I could insert to delete to the RIGHT of the hypen?

 

[bdreed35]

Thie will get you everything to the left of the hyphen:

If Instr(JOBTITLE, '-') > 0 then
  Left(JOBTITLE, Instr(JOBTITLE, '-')-1)
else
  JOBTITLE

~Brian

 

[hilfy]

To delete to the right of the hyphen, try this:

If Instr(JOBTITLE, '-') > 0 then
  Left(JOBTITLE, (Instr(JOBTITLE, '-') - 1))
else
  JOBTITLE

-D