Need to get the Second Character in a String Field

[stalukder]

Hello,

I need to pull the second character out of a field. The Field is a string. My field can display the following...

F9CC, F8CC, P8CC, F7CK, F6CC, P7CC, etc. I want to pull the second character (the #) so I can use that for a formula.

What formula should I use to get the second character? Thank you.

Sharif

 

[FireGeek21]

Here is the formula...

MID({TABLE.FILED_NAME}, 2, 1)

Hope it helps.

Tammy

 

[stalukder]

Awesome, that easy. Thank you!

 

[FireGeek21]

You're welcome.