Two part question:
I have a string in a dropdown to a text field that says something like this:
Wednesday 10/01/2023 Hello
1. I would like to extract the date to a text field so it only says 10/01/2023
2. I would also like to Extract this Wednesday 10/01/2023
Please and thank you
Sorry for the late reply! Thank you for the help Imran-Ami! That worked perfect.
@kgiles123 - there are likely many creative methods to achieve this.
One method (assuming your text field is in a Label)
Question 1:
Index(
Split(
Label1.Text,
" "
),
2
).Value
Question 2:
With(
{
_get_text: Split(
Label1.Text,
" "
)
},
Index(
_get_text,
1
).Value & " " & Index(
_get_text,
2
).Value
)
MS.Ragavendar
32
Michael E. Gernaey
19
Super User 2025 Season 1
WarrenBelz
18
Most Valuable Professional