Add to one column

[Swathi_Raju]

Hi

I have input string like=“AaaBbbCccDdcEeeFffGggHhhIiiJjj”

Based on capital letter i need to split and add to one column Names is it possible like that, then yes can any one help

I tried but not getting exactly output

[Praveen_Mudhiraj]

For your out put you can try like this way

steps:

1. create build data table with one column “Names” and variable = dt
2. Take for each row activity and pass the this regex expression
   System.Text.RegularExpressions.Regex.Split(str,“(?=[A-Z])”)

inside the loop

take add data row activity and pass the {currentitem} and dt in that

3. Out Of the loop use the write range workbook activity to write to excel

output : -

where str = “YourText”

let me know its working or not for you

@Swathi_Raju

[Swathi_Raju]

I tried it’s working but in the first of Names column its coming empty row how can i then…?
@Praveen_Mudhiraj

[Praveen_Mudhiraj]

Hi @Swathi_Raju

you can try this then it will remove the that

take assign activity and pass like this

dt =dt.AsEnumerable.Where(Function(x) x(“Names”).ToString<>“”).CopyToDataTable

you can see the output

@Swathi_Raju

[Praveen_Mudhiraj]

let me know its working or not for you

@Swathi_Raju