Create column based on Start Index or End Index

[devssolution]

Hi All,

In power bi can I create column based on start index to end index (or use the dashes to delineate the columns)

I think It's possible with Measure Column, but I need to create new column in source. 

Column 1                     Column 2                C3      C4          C5                         C6      C7                        c8          c9          C10                     C11             C12
------------------- ------------------------------ -------- ------ ------------------------------ ------ ----------------------- -------------- ----- ----------------------------- ------------- -----------
00/15-09-062-22W5/0 CHEVRON HZ GRIZZLY 15-9-62-22   0475401 0Z41   Ensign Drilling Inc.              785 02 Aug 2016 02:30:00 AM St. Albert     0045  Chevron Canada Limited                      Drill To LD
00/12-21-063-17W5/2 TRILOGY HZ KAYBOB 12-21-63-17   0478631 0Y52   Precision Drilling Corporation    391 02 Aug 2016 06:00:00 AM St. Albert     A1C9  Trilogy Resources Ltd.                      Resumption 
05/08-32-063-04W6/0 7GEN HZ 105 KAKWA 8-32-63-4     0478444 A6XF   Citadel Drilling Ltd.               1 02 Aug 2016 11:00:00 AM Grande Prairie A54C  Seven Generations Energy Ltd.               Drill To LD
00/04-33-064-22W5/0 HALO MCKINLEY 4-33-64-22        0479187 0X47   Beaver Drilling Ltd.                3 29 Jul 2016 03:45:00 PM St. Albert     A6GH  Halo Exploration Ltd.                       Drill To LD
00/04-33-064-22W5/0 HALO MCKINLEY 4-33-64-22        0479187 0X47   Beaver Drilling Ltd.                3 29 Jul 2016 03:45:00 PM St. Albert     A6GH  Halo Exploration Ltd.                       Drill To LD
05/09-09-064-04W6/0 7GEN HZ 105 KAKWA 9-9-64-4      0479398 A6XF   Citadel Drilling Ltd.               2 02 Aug 2016 08:00:00 AM Grande Prairie A54C  Seven Generations Energy Ltd.               Drill To LD

Thanks & Regards,

Sandeep

[BhaveshPatel]

Can you please post your expected output.

Thanks & Regards,

Bhavesh

[devssolution]

Thanks For Rply Me,

I need to create column based on number of character. Here I add following output structure.

 Sample File

[BhaveshPatel · Accepted solution]

Spoiler

Hi Sandeep

Please see below attached file for your solution.


https://drive.google.com/file/d/0B5-C_3XrFPdOZEYyaDhWOTNIMEU/view?usp=sharing

Please mark it as a solution if you think it has solved your problem so we can close the thread.


Thanks & Regards,
Bhavesh

[BhaveshPatel]

Hi There,

To do that, 

Please follow the below stwps:

In the Query Stage,

Go to Transform tab and select the split column as outlined in screen shot.

and then select by the number of characters and it will pop up with a dialog box as outlined in below screen shot.

And you are done.

Step 1Step 2

Thanks & Regards,

Bhavesh

[PavelR]

Hi @devssolution, I am not really clear what is the result that you want. Please can you describe more simple the intended outcome?

Regards.

Pavel