deeproject
New Member
- Joined
- Oct 26, 2016
- Messages
- 10
hi,
i have database with various word inside [ ] , i want to delete every last of them but keep the other word.
i been searching in web for hours but cant find it,
fot instance i have data like bellow
<tbody>
</tbody>
<tbody>
</tbody>i want to clean up to
<tbody>
</tbody>
i have database with various word inside [ ] , i want to delete every last of them but keep the other word.
i been searching in web for hours but cant find it,
fot instance i have data like bellow
Kayu Putih Rw 13 Kel Kayu Putih Kec Pulogadung [Permit Reject To Be Dismental Tiang Icon+] |
<tbody>
</tbody>
Pemukiman Rw 02 Kel Cilandak Barat Kec Cilandak [Area 70% Digusur Untuk Jalan Tol] [Permit By Inhouse : 26 09 2016] |
<tbody>
</tbody>
Kayu Putih Rw 13 Kel Kayu Putih Kec Pulogadung Pemukiman Rw 02 Kel Cilandak Barat Kec Cilandak is there any formula to do it since the data about 1500 any help will be appreciated. thankyou |
<tbody>
</tbody>