How to get specified string from a sentence

No worries if these value are in each row one after the another then you can pass the datatable to a FOR EACH ROW activity and inside that loop use this assign activity like this

Str_output = Split(row(“yourcolumnname”).ToString.Trim,” “)(1).ToString.Trim

If all of them are in one cell like if this is a single value with multiple lines it
Then the activity used will be

—use a assign activity like this
Arr_line = Split(str_input.ToString,Environment.Newline.ToArray())

Where arr_line is a array of string type

Now use a FOR EACH activity and pass the above array variable as input and change the type argument as string

Inside the loop use a assign activity like this

Str_output = Split(item.ToString.Trim,” “)(1).ToString.Trim

Cheers @HeartCatcher

3 Likes