MID function not working

[erezzoni]

HI, I am trying to fin a certain cod in a string it always start with "PC" and the a number and it always finishes with "/"

I am using the following expression:

mid( FIELD ,Index(FIELD, 'PC'), index(FIELD, '/') - Index(FIELD, 'PC'))

It was working fine ... until I came to the following string: 

PEDIDO/RTO1286/PC2247/AC

It dosnt work in this string. All I can find is that the reason is because of the "/" character before PC

Can it be? Is there a workaround for this?

Thanks in advance

[chriscammers · Accepted solution]

I think the subfield function might help you.

SubField(SubField([YourField],'PC',2),'/',1)

So this would be a two step process the inside function would give you  '2247/AC'

The outside function call would remove the rest giving you '2247'

This is one of my favorite functions I hope you find it helpful.

Chris

[erezzoni]

Thank you very much Chris! 

Problem solved