Text to column using RegEX

[HassimDiallo]

Hello, i have sample Data and need to text to column using regEx. the issue is when the expression runs the outputs are Null. 

Sample Data

Header

0111 1254589789         0000003895 2121245894 000000000000000015 D USD 000000000 0000000

I am using Parse Output Method

regular expression: (.{5})(.{23})(.{11})(.{10})(.{26})(.{7})(.{4})(.{7})(.{11})(.{11})(.{11})(.{24})(.{40})(.{10})

What does expression (.{5} represents? i think i might need to update the expression in order for this to work but not sure what the expression means.

Thanks,

Hassim

[MarqueeCrew]

@HassimDiallo ,

. represents any character

 {5} qualifies it to 5, so five of anything

 () the parenthesis explains it as a group. 

cheers,

 mark

[MarqueeCrew · Accepted solution]

Left([field],5)

substring([field],5,23)

 etcetera is an alternate way. 

cheers,

 mark

[HassimDiallo]

Thank you Mark. i just confirmed the expression is correct and lined up with the Data. ideally it should parsed and give me 14 separate Columns. for some reason it is not working. Is there anything i am missing  or i can do?

Made up Data and expression to parse:

0002 9999999999 0000999999 00000000 0000000000080000000 Credit USD 0000000000 99999 9000009999 0099999999 0000 0000000000000000000000 0000000000

[HassimDiallo]

Mark - please disregard. i got it to work. i just had to update the expression to fit my data. i accepted your solution. Thanks!