Extract the FIRST string in a text

Help
1

msg

I want to extract the first part with the numbers “756835” and remoe the date and time from my variable. How to achieve that?
PS. the numbers and date/time is dynamic so my program extract NEW values all the time.

1 Like
2

you can use gettext activity to extract data,

  1. the output will be string with contents "756835 201-04-03 "
  2. you can use Arr = split(stringvariable," ").tostring, you will get array of two string arr(0) and arr(1)
    3)arr(0) is your answer

thanks
Yogananda

3

Okay thank you!

How do i then add this to a Write Cell activity?
msg

It does not allow an array to write cell

EDIT: Nevermind! Fixed it :slight_smile: Thanks again!

1 Like