Excel sheet data updation

[Gopalakrishnan_K]

I have an excel sheet with list of username as shown:

All entries have . and - succeeding the username. How can remove this dyamically as there are around 200 entries and It isn’t easy to manually remove.

[1996 (Neelima G)]

Hi Gopalakrishnan_K,

Please try below code:
Use Assign Acitivity
`stringvalue=stringvalue.Replace(“.”,“”).Replace(“-”,“”)

Find below attached workflow below

[ReplaceString.xaml|attachment]
(upload://d5gz6wmT6nxWFsNYOWQoEfNK7M1.xaml) (4.7 KB)

Hope this helps.

Regards,
Neelima.

[1996 (Neelima G)]

check below workflow for References
ReplaceString.xaml (4.7 KB)

[1996 (Neelima G)]

Hi @Gopalakrishnan_K,

If solution is working for you please mark it as solution.

Thanks,
Neelima