Select letters to the left of a charachter

[genious]

I'm not sure if it is possible but I am trying to separate text from an imported file.  A sample of the text I am given is as follows;

Flicker/18/70/O 

I would like to be able to separate the different parts into separate fields.  

Field 1 = Flicker

Field 2 = would be 18

Field 3 = 70

Filed 4 = O

Is there some calculation I could use to do this?

Many thanks for all help

 

[comment]

How about:

Let (
v = Substitute ( Yourfield ; "/" ; ¶ )
;
GetValue ( v ; 2 )
)

to extract the "18" part? Change 2 to 1, 3 or 4 to extract the other parts.

[genious]

Many thanks comment. That works perfectly, I would love to get a better knowledge of the calculations functions.

 

Kind regards,