Power query - transform help

Hey all!

So I'm working with an excel sheet that I've had running for a while now, that using power query takes data like the below example

A-01-01-A
00912300123A050
A-02-01-A
09312341233A050
09312341233B050
09312341233C050

and makes it look like this ( | signifying a new column)

A-01-01-A
00912300123A050 | A-01-01-A
09312341233A050 | A-02-01-A
09312341233B050 | A-02-01-A
09312341233C050 | A-02-01-A

This has been working great however we recently changed some of our data and now I need to change the power query to do the same but the data will now look like this

A02A01
09312341233C050

Is there a way I can edit the transform / get? to make this still work the same way, the short 6 digit bit will always be 6 digits but varies in it's characters i.e F2G123 FS1BF2

Please Login or Register  to view this content.

as you can see with the code it usually searches for "-" and then moves that to column 2

I'm sorry if this post doesn't make too much sense, It's hard to explain.


----- SOLVED ------ used M language = Text.Length and the rest was straight forward