Number extraction

[Ziyaad_Conrad]

Hi all

I have the following string:

2020/01/24 ELEC INTERIM 9600165 0.000 0.000 EL007H 100000 1660.000 2539.47 380.92 2920.39

I would like to know how to extract and output “1660.000” only.
Please assist
Thanks

[Divyashreem (Divyashree Muddagangaiah)]

if the values are always in bold which you want to extract please follow the below thread

Extract only BOLD characters

@Shriharsha_H_N Step1: Save as Word document as .htm file format Use a read text file activity to read .htm file path Step2 : use below regex function to get required values System.Text.RegularExpressions.Regex.Matches(.htmOutputvairable,“(?<=<b>).*(?=</b)”) in for each Check and let me know still your are facing any issues Thanks Amar.

[jatinnandwani]

Welcome to UiPath Forum @Ziyaad_Conrad

Store it in a String Variable, assuming

baseStr = " 2020/01/24 ELEC INTERIM 9600165 0.000 0.000 EL007H 100000 1660.000 2539.47 380.92 2920.39"

Next is create baseStrComponents as an Array of Strings

baseStrComponents = baseStr.Split(" "c) // This would give you an array generated from the above string after its split with a single space

targetValue = baseStrComponents(baseStrComponents.Length - 1 - 4) // This would give you the fourth value from the last

Also, if the index of the value is not going to stay the same then you’d have to figure out a different way

[bcorrea (Bruno Correa)]

Hi welcome to the community!
For us to help you, please tell us what is different about 1660.000 among all other numbers in your string?