cancel
Showing results for 
Search instead for 
Did you mean: 

substring

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Use in a formula a Text-function like BEGINS(text, pattern), etc.

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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