String manipulation in data

Help Studio
, ,
1

I need to extract number 30 from below data.
Note that the data is dynamic. the data keeps on changing.

00:00:30.4451618

2

Also how to extract only 00:00:30 number and exclude numbers after dot

3

Hello @basavarajbennur07

You can use Regex to get the number.

Assign str_result = System.Text.RegularExpressions.Regex.Match(str_input,":(?'Number'\d+)\.").Groups("Number").ToString

Download file here:
Regex.xaml (8.5 KB)

Regards
Soren

4

Also how to extract only 00:00:30 number and exclude numbers after dot

5

string looks like hours, minutes, seconds, milisesconds

also have a look here:

grafik
grafik379Ă—133 18.4 KB

1 Like
6

grafik

7

Hi @basavarajbennur07

Try this string manipulation

This image depicts a sequence of actions in an automation workflow where a string representing a timespan is assigned to a variable, split at a period character, and the resulting timespan is displayed in a message box. (Captioned by AI)
This image depicts a sequence of actions in an automation workflow where a string representing a timespan is assigned to a variable, split at a period character, and the resulting timespan is displayed in a message box. (Captioned by AI)661Ă—462 16 KB

This image shows a flowchart from a process automation tool, where an "Assign" activity saves the result of splitting an input string into a "Seconds" variable, followed by a "Log Message" activity that logs the value of this variable. (Captioned by AI)
This image shows a flowchart from a process automation tool, where an "Assign" activity saves the result of splitting an input string into a "Seconds" variable, followed by a "Log Message" activity that logs the value of this variable. (Captioned by AI)693Ă—375 13.5 KB

Output

image
image462Ă—155 3.97 KB

8

Peter’s posts are definently the “most correct” way of achieving what you are looking for.

9

str_data=“00:00:30.4451618”
please use below syntax to get required output:
str_data.Split(".“c)(0).Split(”:"c).Last()