Issue in Split

[Latif]

Hi,

Some times back i got help on split a value…
I alt: -215,29

I got help to split this so that it’s not showing the text before… and only shows the value after ( … like this
Split(Upd_InterestRateValue,“:”).Last.ToString.TrimStart

Now i want to split this agian so that it wont show me that - minus sign and only show me int value (price)…

I have tried using same formula by changing : to - but its not wokring…

Can some one help me…

[Pradeep_Shiv]

Split(StringVariable.tostring,“: -”).trim

[ImPratham45 (Prathamesh Patil)]

Var.Substring(Var.LastIndexOf(“-”)+1)

[Latif]

I got it my self… thanks alot for help.
But i have used:
Split(Upd_InterestRateValue,“-”).Last.ToString.Trim

Is it right what i did or wrong?

[Divyashreem (Divyashree Muddagangaiah)]

if you just want to remove - you can also use replace or remove method Upd_InterestRateValue.replace(“-”,“”)

[Palaniyappan (Forum Leader)]

@Latif

Split(Upd_InterestRateValue,“-”).Last.ToString.Trim

This is perfect buddy
But if the value sometimes doesn’t have any minus then it will not give any output
So in that case to make it reliable use a expression like this

In the Input is stored in a variable named str_input
Then in assign activity

str_output = System.Text.RegularExpressions.Regex.Match(str_input.ToString,”(\d).*”).ToString.Trim

This will give only the numerical value even if it has minus or without minus

Cheers @Latif

[Latif]

I always getting this Error on regular expretion and dont know how to solv it.
I tried with ;" and with ." and with ,*" but still same error.

And i did not copy-ed your i have typed it.

[Pradeep_Shiv]

@Palaniyappan

System.Text.RegularExpressions.Regex.Match(str_input.ToString,”(\d).*”).ToString.Trim

System.Text.RegularExpressions.Regex.Match(Upd_InterestRateValue.ToString,“(\d).*”).ToString.Trim

[Latif]

I tried it still says invalid character even with .

[Pradeep_Shiv]

@Latif

I alt: -215,29

I alt: -215,29 from this you want only number right?

[Latif]

yes after i know that i got value in minus then i want to check this minus value with the excel value which has no - minus sign.

[Pradeep_Shiv]

Main.xaml (4.8 KB)
cheers @Latif

[Latif]

thanks my regular expression is working now… and i got the value out with expression. thakns Pradeep_shiva and palaniyappan

[Latif]

by the way… you gave me another way to solv this regular expression issue… perfect… to good brother… Have a nice day…
kindly check my other thred about DATE issue.

[Pradeep_Shiv]

sure!