on 02-21-2007 6:44 AM
Hi
Can anybody tell me how to get the position of any character.
like if i have a string like "user.datasource.un.alex"
I want the string alex.How to get that???
Thanks
Monika
Use in a formula a Text-function like BEGINS(text, pattern), etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario Herger /Monica
I feel "Begins" returns a boolean value and since your requirements is to get the name dynamically , i feel current version of VC( ihave worked till sp4) does nt have such functionality which can suffice to your Requirement.
Thanx and Reagrds
Pankaj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Monika can use of these functions
AT (text, pos)---Returns the character at the specified position
Expects: text str A text string
pos int Zero-based index of the desired character
Returns: str The requested character
and if your are looking something to get the name of the user only can use
MID(@UNIQUEID,27,LEN(@UNIQUEID)-27) where in it rtuens the value of the string @UNIQUEID(name of the variable) after 27 postion.
Thanx
Pankaj Prasoon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.