Hi ,
I need to extract a part of a string from an excel and paste in to new row.
the string is in below format.
Input in a row
karthik is a uipath developer # 7z3456 #8p6789
the output should be(in separate rows : 7z3456 ,8p6789
You can split the string based on “#” character.
InputString = “karthik is a uipath developer # 7z3456 #8p6789”
Create a variable of type ArrayOf[String] ( Eg : InputStringSplit )
InputStringSplit = Split(InputString , “#”)
The output of InputStringSplit(1) will be “7z3456” and InputStringSplit(2) will be “8p6789”.
You can now use the above operation inside a For Each Row activity and assign these values to row(“ColumnName”)
Eg:
Let us assume that the column names would be “FirstNum” and “SecondNum”
row(“FirstNum”) = InputStringSplit(1)
row(“SecondNum”) = InputStringSplit(2)
1 Like