I have attached a sample excel file, I’m trying to split the excel column. In the user name column there are names and after the name there is a number that begins with N. I need to take the number that begins with N and split it and add it into the number column while keeping the names in the User Name Column. Any help or workflow would be appreciated.
Vignesh,
Nice work and thank you, is there a way to keep the N from the number when added into the number column? the number would be n34576 instead of just 34576.the number have a capital N and a lower case n In the
original. I posted the excel sheet with the the numbers having a smaller case n. Thanks again this is going to save me if i get this figured out in the next hour matchtest.xlsx (10.8 KB) excel sheet some of
Vignesh,attached
I have a few more issues, I have attached the file I’m working with. its has many rows and some of the name don’t have the N2345 number and im getting the error when i run it with the attached file. it should just run through each user name and split the string like we did earlier and if there is no number just move to the next one. Any ideas? new split.xlsx (18.8 KB)
Could you share a picture of the properties panel for the invoke code activity? i have never used this activity before and my code is still in the learning process