This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 53%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
I need to extract the date field from the string. But unable to retrieve it fully -
Output expected is 04 03 22 but I only get 04. Please advise me here
Thank you for posting query in Microsoft Q&A Platform.
Since Your numbers at then end of string, You can consider using split() function on top of string based spaces. This gives you array and then calculate length of it and then take last 3 index values to concatenate.
Please let me know how it goes.
Hi @Vivek Komarla Bhaskar , Just checking if above helps? If you are still facing any issues with expression to write, then kindly feel free to revert. Also, if you found any other way to implementing same then feel free to share with community as well.
If above helps, please consider hitting Accept Answer button. Accepted answers help community as well.
My screenshot worked by just adding ( at the start and ) at the end.
Great. Awesome job. Thank you for sharing this with community. This helps all the community members.
-----
Please consider hitting Accept Answer button. Accepted answers help community as well.