Connecting Tech Pros Worldwide Forums | Help | Site Map

How to remove the first three characthers from a string

galsaba
Guest
 
Posts: n/a
#1: Nov 13 '05
I have text field that contains strings of various lengths.
I want to get rid of the three first charachters:
Instead of "see I am from here"
i want to see " I am from here"
instead of "see they are from there"
I want to see "they are from there"

etc. what would be the right function?

Thanks

galsaba


Arno R
Guest
 
Posts: n/a
#2: Nov 13 '05

re: How to remove the first three characthers from a string


What about
Me!NewString=Mid(Me!OldString,4)

or
Me!NewString=Trim(Mid(Me!OldString,4)) to get rid of spaces before and after

--
Hope this helps
Arno R

[color=blue]
> Instead of "see I am from here"
> i want to see " I am from here"[/color]
[color=blue]
> instead of "see they are from there"
> I want to see "they are from there" [/color]

PS: What happened to the space here ??


Closed Thread