 Hello, welcome to SSUriTeX, just in this side and this is continuation of Power BI tutorial. So in the last videos we have seen how we can pivot the table and how we can unpivot the tables. So today we will see how we can split the columns. So in the splitting of any column we are having few options as we can see we can split the column by using delimiter. Second is by number of character, by positions, then by lower to uppercase, then upper to lowercase, then digit to non-digit and non-digit to digit. So these are the options available by which we can split any column. So what it means and how we can implement in the real time just move to Power BI desktop and we will see. So now let us move to Power BI desktop and where we will see one by one. So here this is our initial project and here as we can see we are having this column that is product name and in the product name as we can see we are having a hyphen to separate the product name with the description. So this is the product name in the left side and in the right side we are having the description. If we will split this column and we want to separate product name in a different column and the description of that in the different column. So how we can do this? So yes we have an option to split column by delimiter. In the delimiter we can specify what delimiter we want. So here we are having this column gamma equal sign semicolon space and tab but we are having a hyphen for that we can use the custom and here we can specify that hyphen and here we can see for each occurrence leftmost delimiter rightmost delimiter. So we just want to each occurrence of the delimiter. So what it means? So if we will have multiple positions for hyphen then it will split those values in different different columns. For example let us assume in the mountain 100 then hyphen then silver then hyphen then 44. So it will split total four columns. First will contain mountain after that 100 after the silver after 44. So that is for each occurrence. The leftmost it will split the column only two when first hyphen will come that part will go to the first column and all the value will go to the right column. After that rightmost it will pick from the right side and the first hyphen from the right side will go to a single column after that all the characters will go to the next column. So just click on ok and we will see. So here as we can see product name dot 1 and product name dot 2. So all these values before the hyphen is available in the product name 1 and all the values after hyphen is available in the product name 2. So it is working that looks good. Just roll back it and we will see the next options here roll back. And now second option as we can see number of characters. So it will pick how many number of characters we just want to replace. For example for a dummy number 5 here we can see once as for left as possible as I told you it will count from the left side in the right it will count from the right side after that repeatedly it means it will repeat for each five characters. So we just want to split only two columns first will contain five characters after that all the vectors now click on ok. So as we can see first it is gonna count five characters and will have in product name 1 and rest of all the characters will go in the product name 2 that is good. Just roll back it and roll back it. Now this is the second option in the third option by position. So what is mean? So just click on this and here we can see the position. So we can specify the positions by which we want to split the columns. And for example as here we can see 0, 2, 5, 10 and 14. So let me use 2, 5, 10. So it will split in three columns click on ok. So it will be gonna count from second position to fifth position after that and after that. So it is having three columns. So just roll back it cancel it and roll back this option that is good. After that we can see we are having by lower to uppercase. So into lower to uppercase as we can see in the right most we don't have anything because all the values is gonna start from uppercase. So just cancel it and we will see next option. So here we can see upper to lower case. So it will split from first character from the left side that is the uppercase and all the characters after that is in lower case. So just cancel it and now digit to non digit. So here we can see we are we don't have a digit at the starting position. So in the column 2 we will not have anything. So in the last option that is by non digit to digit. So it will split from non digit will come in the left column and in the right column will have digit and after all the characters from the that digit. So just roll back it and this is our initial column. I hope you have understand about the split column. So if you like this video please subscribe my channel to get many more videos and don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.