I am unable to convert the value of 72.1 lac -22.1 Cr to numeric form

[Adithyeshwar_goud]

i need a code to convert the string in index 0 to integer values as follows :
note:i need only values in index 0

index0-index1
19.8 Lac - 48 Lac
1.70 Cr - 2.50 Cr
57.2 Lac
1.29 Cr - 1.35 Cr
2.37 Cr - 3.39 Cr
58 Lac - 93 Lac

1.74 Cr - 2.01 Cr
72.8 Lac - 1.01 Cr
2.73 Cr - 2.76 Cr
(Call for Price)
8.86 Cr - 11.89 Cr
1.71 Cr - 3.22 Cr

76 Lac - 1.29 Cr
99.2 Lac - 1.17 Cr
83 Lac - 95.8 Lac
(Call for Price)
23 Lac - 31.2 Lac

1.85 Cr - 2.05 Cr
74.2 Lac - 74.4 Lac

to
1980000
…
…
…

[Anil_G (Anil Gorthi)]

@Adithyeshwar_goud

If the string contains 1.98 Lac - 2.22 Cr

Then use as below

Requirednumber = If(str.Split("-"c).First.Contains("Lac"),Cint(Cdblstr.Split("-"c).First.Replace("Lac","").Trim )*100000)), Cint(Cdblstr.Split("-"c).First.Replace("Cr","").Trim )*10000000)))

In integer format

Cheers

[Adithyeshwar_goud]

bro i am unable to modify the code so can you plz spare 5 min of u r time and check the flow and give a code
test 2 beta.xaml (237.2 KB)