If i want to split entry in the column "H", how to define this? And if i want to split the entry with different separator. For example if i have a entry like "Name/Mail Id - password" how to define the multiple separator and how to make to do this task untill the last entry instead of giving 1 - 5/1-50 ?
2 requests..... a) can you show how to split 1 item into 3 with same delimiter being there twice. b) what if i dont want to define the length of the columns. You hard coded 1 to 5 into the loop.....however what if i wanted the system to check and exit if there is no more column after the last one......for example, the system automatically detects there are only 5 line items that can be split and then exits. How do we code that ? Please assist with both requests.
Sir r are amazing ,aaj subah se bohot pareshan tha apki video mili abb jakar
Terimakasih banyak
Thank you so much👍👍👍👍👍
Welcome
If i want to split entry in the column "H", how to define this? And if i want to split the entry with different separator. For example if i have a entry like "Name/Mail Id - password" how to define the multiple separator and how to make to do this task untill the last entry instead of giving 1 - 5/1-50 ?
2 requests.....
a) can you show how to split 1 item into 3 with same delimiter being there twice.
b) what if i dont want to define the length of the columns. You hard coded 1 to 5 into the loop.....however what if i wanted the system to check and exit if there is no more column after the last one......for example, the system automatically detects there are only 5 line items that can be split and then exits. How do we code that ?
Please assist with both requests.
great video