>>>I think I've used this before. Thought it worked as expected, but why isn't this working like I expect it to:
>>>
>>>

>>>m.Notes = "  " + chr(9) + "Notes"
>>>m.Notes = alltrim(m.Notes, 0, chr(9))  && Leading spaces and tab are still present
>>>m.Notes = alltrim(m.Notes, 1, chr(9))  && Leading spaces and tab are still present
>>>

>>>
>>>Maybe something obvious I'm not seeing? Maybe I'm not awake yet? Maybe the brain is turning to mush?
>>
>>You didn't ask to remove spaces, only tabs. It should be
>>

>>m.Notes = alltrim(m.Notes, 0, chr(9), SPACE(1))
>>

>
>Oops, sorry guys. Your posts were not showing up in the reply list and so I didn't see them until after my post where I figured it out. I think I was thinking that if you only ask for chr(9) it would remove that and the result would be " Notes", but since you're not asking it to remove spaces, I guess it sees a space as the first character of the string and then doesn't do anything else. I will assume I was not awake yet instead of the brain turning to mush.


I didn't know parsechar parameter of alltrim. That's good... Thanks... :)