Removing the first and the last letters

[Tim6]

Hi there, 

 i'd like to remove the first 5 characters and the last 5 characters.

All Characters:

TBHHH12345678TBHHH

Can you please let me know what formula i can use to do this? 

Thank you,

Jessica

[MarqueeCrew]

@Tim6 

Substring([field],5,8)

 of the string is always the same.  If you want to strip all letters, use a cleanse tool.  

cheers,

 mark

[AbhilashR · Accepted solution]

Hi @Tim6, you could try something along the lines of the following:

Substring(
		Left([Field1],Length([Field1])-5)
		,5
		,Length([Field1])
)

[Maskell_Rascal · Accepted solution]

Hi @Tim6 

Try this:

Substring([Field1],5,Length([Field1])-10)

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[Qiu · Accepted solution]

@Tim6 
A bit late for the party.

Some different with RegEx.