Search Results

Search: Posts Made By: kottursamy
1,998
Posted By kottursamy
Split a record ( in a row) and make it as new row
Hi All,

Record is splitted by ';'. I need to handle the special character and make the ';'-separated data in to rows

Thanks!!!
1,998
Posted By kottursamy
Split a record ( in a row) and make it as new row
Hi All,

The following is the scenario

id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....

I need the following output

id name
--------------
1 William...
Showing results 1 to 2 of 2

 
All times are GMT -4. The time now is 03:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy