Substring

Help
1

hi How can i get “150” out of this text (yearly plan 150y flexi)

2

Use Regex to get only number

3

Use Assign strPlan = strInput.substring(strInput.indexof(“yearly plan”)+12),3)

4

image
image1366×768 73.2 KB

error shown

5

@goharmalik clarify onething you needs to do substring only for this string or you needs to take only number from the string?

6

Hi @goharmalik,

you gave extra bracket in the query can you remove and check it.

strInput.substring(strInput.indexof("yearly plan")+12,3)
Regards,
Arivu

7

I will suggest using regex
here is a workflow that does that

Main.xaml (5.8 KB)

enjoy :wink:

8

Hey @goharmalik

you can use Regex here too - Simply “\d+”

Reference - Sample.xaml (5.8 KB)

Regards…!!
Aksh

9

hi i need to substring only this string. to get 150 out of this whole text

10

Than you can use this it works

11

Thanks all every ones solution was perfect

12

HI i am stuck in this situation sometime instead of 150 it is 1000 so i have to write 4 instead of 3 is there any way to tacke it and when i write 4 it takes value 150y when the value is 150y.i want values to b 150 and 1000 only .Kindly help me out

13

(yearly plan 150y flexi) i want to get 150 and repalce y with empty space or with 0.

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.