I have a flat file with columns empno, ename, address
1001 , ravi , marathahalli,bangalore
1002 , shiva, sr nagar, Hyd
1003 , ram , vasi, mumbai
Here my delimiter is comma(,), but in address column address separated by comma(,) my target is db, need output as empno ename address
1001 ravi marathahalli,bangalore
1002 shiva sr nagar, Hyd
1003 ram vasi, mumbai
Kindly help me to achieve the above requirment.
Thanks in advance.