Hi All,
Please could you help me parse with Regex the below details i took from sftp location.
How to filter out the file name?
-rw-rw-rw- 1 user group 108057 May 9 2020 20200504_Cobra_3sensemedia.csv
Thanks,
Preethi
Solved! Go to Solution.
Here is another way to do it.
Formula
GetWord([Text], CountWords([Text])-1)
Workflow:
Here
CountWords([Text]) gets number of words
CountWords([Text])-1 gets last word position (since position is from 0 to n-1)
GetWord([Text], CountWords([Text])-1) gets the word at last position
Hope this helps 🙂 Feel to ask if you have any questions