While searching in kibana, can i use substring on a field?

I think the answer is, it depends. In any place you would be using Painless, for example, in Kibana's scripted fields, you can use Regex to do substring matches on a field-value.

See here for an example: Substring in painless

hope it helps
Rashmi