In Excel file in one column (D) I have values:
EEPL1Training Fees
ML001Training Fees
ML014Training Fees
ML014Training Fees
ML014Training Fees
ML015Training Fees
I want to split, example:
EEPL1 Training Fees
ML001 Training Fees
ML014 Training Fees
ML014 Training Fees
ML014 Training Fees
ML015 Training Fees
And result ( EEPL1, ML001, ML002, ML003…) write in same excel file like new column (column Name ID ), and Training feeds I want to stay in same column like Description.
If you want to do it in the bot logic, you need to loop through your datatable and split each row
myStr = “EEPL1Training Fees”
strID = myStr.Substring(0,5).Trim
strDesc = myStr.Replace(strID,“”).Trim