How do I Remove the Digit And hyphen from the Excel Datatable?

Help Studio
1

image
I have attchaed the SS for better understanding

I want only Book, Class and so on wan to remove Digit and Hyphen Prefix.

2

Hi @kishan.savaliya

You can do it by data manipulation(Substring method, split method etc)

1 Like
3

@kishan.savaliya Use below expression.
CurrentRow(“Name”).ToString.Trim.Split("-"c)(1)

1 Like
4

@kishan.savaliya
testt.xaml (7.8 KB)

1 Like
5

Hi @kishan.savaliya,

image
image737×476 22.1 KB

Cheers,
Kiran T

1 Like
6

Thanks all of you for Solution @tkiran @jack.chan @sb001 @loveleet_Saini

1 Like
7

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