Substr and Index | OutSystems

Paulo Torres

Champion

Substr and Index

Question

Hello everyone!
In my espace i have one parameter with, for example: 15-18. And i want get the number before hifen and the number after hifen.

For number before hifen i used :Substr(IDs,0,Index(IDs,"-")-1) and workly.
With Substr and Index, can i get the number after hifen? How?

Best Regards, Paulo Torres

29 Mar 2012

Nelson Baptista

Staff

Hi Paulo,

You can get the number after the hifen using : Substr(IDs,Index(IDs,"-")+1,Length(IDs)).

Regards,
Nelson Baptista

29 Mar 2012

Nelson Freitas

Hi Paulo,

If your sure that the number after the hifen always has 2 chars, then you can use:

Substr(IDs,Index(IDs,"-")+1,2)

If you don't know how much chars exists after the hifen, then you can use:

Substr(IDs,Index(IDs,"-")+1,Length(IDs)-Index(IDs,"-")+1)

Hope this helps.

Cheers,

Nelson Freitas

29 Mar 2012

1 reply

26 Sep 2019

Show thread

Hide thread

Nikhil Gondane

Nelson Freitas wrote:

Hi Nelson,

SyntaxEditor Code Snippet

Search variable storing information like "#Employee#Manager"

Index(Search,"#"+Salary.Designation+"#")<>-1

Can any one explain me above syntax what is showing ?

And another query is -1 in Index function means ?

Thank you for your time !!!

26 Sep 2019

Paulo Torres

Champion

Thank you very much NelsonS :)
All solutions works, i only have to choose one!!

If i have in parameter 13-15-19, how i get the third number??

Thank you very much my friends

Paulo Torres

29 Mar 2012

Nelson Freitas

Paulo,

the Index(string,search) function returns the first position where the search is found. To find the last position, you can use the String_LastindexOf that exists on the Text extension i'm sure you use somewhere in your platform (because its installed).

So, you can use the same previously code, but instead of using the Index function, you use the String_LastIndexOf

Cheers,

Nelson Freitas

29 Mar 2012

Hélio Dolores

Staff

Hi Paulo,

Add the "searchFromEnd" optional parameter in the Index(IDs,"-") part.

Hope it helps,

HD

29 Mar 2012

Nelson Freitas

Oh,

Helio is right too. I assumed you were not using Outsystems lastest version. In the 6.0 version, the Index function has several inputs that you can play with. The previous versions (never use that function on 5.1) just has the first 2 inputs and thats why I mentioned the String_LastIndexOf.

Cheers mate,

Nelson Freitas

30 Mar 2012

Rui David

Hi Paulo,
Try this:

Action: String_Split("13-15-19", "-")
Assign: Value = String_Split.List[1].Text.Value

String_Split action is part of text extension

Regards,
RD

30 Mar 2012

2 replies

Last reply 26 Dec 2022

Show thread

Hide thread

Paulo Torres

Champion

Rui David wrote:

Hi Paulo,
Try this:

Action: String_Split("13-15-19", "-")
Assign: Value = String_Split.List[1].Text.Value

String_Split action is part of text extension

Regards,
RD

Thanks Rui.
Your picture helps me a lot :)

Hugs

30 Mar 2012

Amir Prince

Value=String_Split.List[2].Text.Value (third value is wanted)

26 Dec 2022

Hélio Dolores

Staff

[2] :)

30 Mar 2012

karthimani R

Hi,

I have an expression phoneno=codevalue+" "+phoneno how to retrieve phoneno alone from the expression using substr and index

01 Jun 2017

Pradip Chavhan

Hi,
I was searching one of the topic where i found this forum.
Please find the below screen shot it might helpful. Here you can put any number 2,3,4 digit no matter. If your number contains hyphen it will give you the number. There are multiple ways to do this e.g.

1] We can use Replace() function

2] substring() & Index() function

3] String_Split() - Server Action

Here i have done using 1,2 ways

25 Jan 2024

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines