Removing the first and the last letters

Question

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

AbhilashR · Accepted Answer

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

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

Maskell_Rascal · Accepted Answer

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 Answer

@Tim6 
A bit late for the party.

Some different with RegEx.