Scan from string and extract string between delimiter

[Michel_Gauvin]

Hello,

Basic questions.  Is it possible with the scan from string regular expression to extract the string that are within the specified delimiters.  Here is an example:

\\Name of folder 1\Name of folder 2\Name of folder 3\File Name

Can the scan from string output the following by specifying the right regular expression:

Name of folder 1

Name of folder 2

Name of folder 3

File Name

I have tried \\\\%s\\%s\\%s\\%s but the %s stops at the first white space.

Thanks,

Michel

[RavensFan]

Why wouldn't you just use the Path to Array of Strings function in the File I/O palette?

[moderator1983 · Accepted solution]

RavensFan suggested the appropriate function for your requirement, however you can also use an alternative, which is 'Spreadsheet String To Array'.

[Michel_Gauvin]

There are days like this, I guess..... 😞