parse string with Regex

[preethisisaac]

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

[echuong1 · Accepted solution]

Are you just looking to grab the last part? If so, the attached should work. It's looking for the last string, separated by a space.

.+\s(.+)

[atcodedog05 · Accepted solution]

Hi @preethisisaac 

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