LEFT function

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

The below query works as expected until I add the LEFT function to get the
left 16 characters. I keep getting the entire string.

Menu:
Left(StrConv(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([SongList]![Title],"The
","")," and ","")," The ",""),Chr(44) & " THE",""),"
",""),Chr(44),""),"(",""),")",""),Chr(39),""),"-",""),".",""),"!",""),1),16)

What am I doing wrong?

thanks
 
What happens if you remove StrConv? If that corrects the problem, could you
format a text box for all caps, or do you need to combine the string with
another mixed case string?
BTW, it seems you are removing all spaces (line breaks in the newsreader
make this a little unclear). If so you may be able to simplify a bit by
removing Chr(44) once, removing "The" once (strConv will ignore the case
unless you specify otherwise), and removing all spaces. However, I don't
know the details of your text, so I couldn't say for sure.
 
Back
Top