How to get only Charcter/Word from Excel Column

hello Guys,
i have one Excel which Contains Data Suppose like
Joya
Joy23
23fd43
1234
so I want only Joya from it

1 Like

i guess this will help you out

Havn’t get idea i just want a word/character data from Excel Column like Above

If you need to get the whole row which contains the keyword Joya, you can use Select statement or Filter table activity. Please see the below links for your reference.

Select statement example below. This will give you the rows which contains only Joya.

Assign OutputDT = inputDT.Select("[Name] = 'Joya'")
2 Likes