How can i extract a word from the start of a string?

Learning Initatives Reboot Your Skills 2021
1

i have a string like
“firstname of test”
how can i extract the word before ‘of’?
also i cannot use the substring method as the firstname will constantly change

2

Split it by giving “of” and then take the zero index. So you will get the string which will be before the keyword “of”

3

Split(strVar,“of”)(0)

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.