'Phn'+ CAST(ROW_NUMBER()OVER(PARTITION BY EmpId ORDER BY EmpId) AS VARCHAR) AS Col,ĬROSS APPLY String_split(EmpPhoneNo,',') AS Split ) Lets split the comma separated phone number list into columns, For this we will use Cross Apply operator, String_Split function and SQL pivot.įollowing query is used for splitting a comma separated phone number list into columns. Split strings in bash is an essential skill in order to operate the terminal and work with scripts and.
You can see the maximum phone number that any employee is having that is four, so you will have maximum four columns that is used to split the comma separated phone number list into these columns as shown in below sample output that you need to implement.Ĭolumns phn1, phn2, phn3, phn4 will be having a phone number values. Choose a web site to get translated content where available and see local events and offers. How you can split strings in bash is shown in this tutorial by using different examples. Now the requirement is that you have to split these comma separated phone number into columns. Lets create a sample table named PhoneNumberList and insert some records into this table as shown below. Suppose you have a table, and one column of this table contains a comma separated string values and you are asked to split these comma separated string values into separate columns, means if string consists five sub string values which are separated by comma then you have to split this values into five columns based on their order.
Split string by delimiter matlab 2012 how to#
How to Split Comma Separated String Values into Columns?
0 kommentar(er)
