Hi All, we have data like this... Select col1 from table; COL1 ---------- WINCOR,WINDOWS XP, 2HI,EMV CARD READER,1500XE, EJ MASKED ABC,DEFGHXP, 2HI,EMV CARD READER,1500XE, EJ MASKED Required output. REQ1 REQ2 REQ3 REQ4 REQ5 REQ6 WINCOR WINDOWS XP 2HI EMV CARD READER 1500XE EJ MASKED ABC DEFGHXP 2HI EMV CARD READER 1500XE EJ MASKED comma position is not fixed, so we need to get comma position by using instr. I know we can do it by using substr and instr. I am trying but it will take huge time to me. So any help?