Excel sheet data updation

I have an excel sheet with list of username as shown:
username
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.

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.

1 Like

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

Hi @Gopalakrishnan_K,

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

Thanks,
Neelima

1 Like

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