Hi all
I want to extract the characters when ever the # is present in the string
eg
1. vijaykumar#121qq22342 --- i want vijaykumar
2. update#thesystem --- i want to extract update
pls help me in this, thanks in advance.
i want to extract the character untill finding the #
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Use Field() function to extract the string till #
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>