taking a part of a string

[#1]

hi

i have two kinds of input  format like:

F16071/0000000241

FF16071/000000014124A20

second one has double F at begining.

And i want only 10 characters after '/'

for these inputs i want  0000000241 as output

thanks

[Jason_Michaelides · Accepted solution]

As per your other post that is the same as this one...

If that is definitely the rule you want to apply then:

LEFT(TEXT(SubField(YourField,'/',2)),10)

or

TEXT(MID(YourField,Index(YourField,'/'),10))

Jason

[#3]

thank you very much