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
)
WarrenBelz
146,635
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional