Hello Gurus

I am banging my head from this morning. Did some google search. Found some example, but not helping me a lot.

Here is the problem

Given string : '152527_OR100006_UHNJ3241159000_1_.pdf'

My task: Parse the string into different column. 

FileID: 152527

SalesOrderNum: OR10006

ItemNumber: UHNJ3241159000

EdiLine: 1

FileType: .pdf

If the size of string was fixed, then it was not a big deal. Size of string is dynamic and "_" underscore is suppose to act as a delimiter. 

Thank you