Split without delimiter

[EberlinM]

How can I split a field, into many other fields, but without using a delimiter, and using the position range instead?

For example:

bignumber = 16563764

I need to split it in:

account id = position [0 to 3] of field "bignumber"

company code = position [4 to 6] of field "bignumber"

operation code = position [7] of field "bignumber"

Thanks!!

[ITWhisperer · Accepted solution]

| makeresults
| eval bignumber = 16563764
| eval digits=split(tostring(bignumber),"")
| eval accountId=mvjoin(mvindex(digits,0,3),"")
| eval companyCode=mvjoin(mvindex(digits,4,6),"")
| eval operationCode=mvindex(digits,7)
| fields - digits

[EberlinM]

Thank you! Worked perfectly!