Split column by Position where position is stored in another column for the same row.

[Anonymous]

I need to Split column by Position where position is stored in another column for the same row.

so I need to get the position number from a different column in same row while splitting the text string for each row.

How do I get this position value dynamically?

Thanks 

[amitchandak · Accepted solution]

In M, in exit query

= Text.Start([Column],[Postion Col])
= Text.End ([Column],Text.Length([Column]) -[Postion Col])

[Anonymous]

Hello!!!

I hope this helps!

For this example i created 2 columns

split_1 = LEFT(Hoja3[COLUMN_1];Hoja3[NUMBERS OF CHARACTERS TO SPLIT])

Split_2 = RIGHT(Hoja3[COLUMN_1];LEN(Hoja3[COLUMN_1])-Hoja3[NUMBERS OF CHARACTERS TO SPLIT])