Copy carachteres from one column to other customized column

[bsouza]

Hi,

I have a column with several carachteres wich came from a .txt file. There are about 250 carachteres for each line in the first colum. Is there a way to create customized columns with just a specific carachteres from this first column?

i.e.

Column1(from a .txt file)                  Column2(customized)        Column3(customized)         Column4(customized)

ABCDEFGHIJKLMN                            ABC                                     DEFGH                                 IJKLMN

Hope it is clear.

Thanks!

[ryan_mayu · Accepted solution]

@bsouza

Is this what you want? Hope this is helpful. Thanks

Column = LEFT(Table2[Column1],3)

Column 2 = MID(Table2[Column1],4,5)

Column 3 = MID(Table2[Column1],10,6)

[v-piga-msft · Accepted solution]

Hi @bsouza,

The solution of @ryan_mayu should be helpful which use dax expression to create the calcualted column.

In addition, you could achieve your desired output in query editor by spliting column which is custom column.

You also could refer to the attachment.

Hope this can help you either!

Best  Regards,

Cherry

[ryan_mayu · Accepted solution]

@bsouza

Is this what you want? Hope this is helpful. Thanks

Column = LEFT(Table2[Column1],3)

Column 2 = MID(Table2[Column1],4,5)

Column 3 = MID(Table2[Column1],10,6)