In the below rows the 16 th column contains 00 or 22 0r 12 ........it may be up to 99 in some ...x rows
DeletedUser-2789644|DomainsRenewed|0|0|0|0|0|0|0|0|0|0|0|0|0|00|0|0|0|
DeletedUser-2789644|DomainsRenewed|0|0|0|0|0|0|0|0|0|0|0|0|0|22|0|0|0|
DeletedUser-2789644|DomainsRenewed|0|0|0|0|0|0|0|0|0|0|0|0|0|12|0|0|0|
-------------------------------------
----------------------------------------
I want to put (|) in between like 12 should became 1|2 22 became 2|2 ih that 16 column
output should be like this
DeletedUser-2789644|DomainsRenewed|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|
DeletedUser-2789644|DomainsRenewed|0|0|0|0|0|0|0|0|0|0|0|0|0|2|2|0|0|0|
-----------------------------------
----------------------------
over all | (pipe) should be inserted after 16 th colum of all rows...
Thanks.
In reply to Replacing with two digits with pipe by venkatperl55
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |