Split column in multiple rows

[jgralow]

I have a column that i need to split, easy enough, however, i need some of the column split by left 3 and some of the column split by left 5. For example, I have a class number SCL355-Cooking, and a class SCLS0276601-TV  The nubers i need are 355, and 276. Is this possible?

[Anonymous]

Hey @jgralow, I would try using "Column from Examples" and see if the Query Editor can figure it out for you.

If you're not familiar with this feature, here's a link to a video I posted:

https://www.youtube.com/watch?v=kJ37glO4wBY

Hope this helps,

Parker

[gregcd]

If the value contains seven numbers like that, do you always want the three numbers at that posititon?

[jgralow]

The value in the column will range from 6 to 15 numbers, the 3 numbers i want to extract will vary depending on the size. 

[gregcd]

You can use several "if" statements to check the length of the value, then if true split at the required position. 

Some info on nested if statements: https://www.myonlinetraininghub.com/power-query-if-statements