I have a text file in that there is a column which contains debit or credit amount in it like :
1000dr accountnolikesomething
2000cr accountnolikesomething
I want to make condition on dr or cr and based on condition it should come on debit or credit like:
debit credit accountno
1000 --- accountnolikesomething
--- 2000 accountnolikesomething