How to use Text to column in uipath studio

Hi, I have 10 records in excel and i want to apply Fixed with menu in this records to split mobile numbers (Ex-91 5576567564)like this. Can anybody tell how to use text to column

Hi @gauthamRPA ,

kindly check this post

Hi @gauthamRPA

  1. Read the data into datatable
  2. Add new datatacolumn for mobile number
    3.then use for each row in datatable
  3. Inside loop use assign
    Currentrow("newcolumn") = currentrow("oldcolumn").substring(3)
  4. Another assign
    Currentrow("oldcolumn") = currentorw("oldcolumn").substring(0,2)
    6 .write data back to excel

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.