How can we remove setain data in a row

Help Studio
, ,
1

sports club responses.xlsx (16.7 KB)
in the above excl sheet i need to get the subscribers in numeric formate ’
example:
if it is 45k subsribers while scrapping i need to enter in excel sheet as 45000 by removing subscribers and replacing k with 000.
any idea mates.

2

Hello @Adithyeshwar_goud

Read Range (Excel Application Scope or Workbook Read Range) // Output: dtSportsClubResponses

For Each Row (TypeArgument: DataRow) in dtSportsClubResponses
Extract and Convert Subscribers
subscriberValue = row(“Subscribers”).ToString().Replace(“subscribers”, “”).Replace(“k”, “000”)
numericSubscribers = Int32.Parse(subscriberValue)

Update Excel
row("Subscribers") = numericSubscribers

End For Each

Write Range (Excel Application Scope or Workbook Write Range) // Input: dtSportsClubResponses

Thanks & Cheers!!!

1 Like
3

Hi @Adithyeshwar_goud ,

Check this workflow hope it will help you

Main 1.xaml (13.4 KB)

Regards,
Vinit Mhatre

1 Like
4

bro i want to write the replaced data in to the subcsribers coloumn than

5

Hi @Adithyeshwar_goud ,

Find updated Flow
Main 1.xaml (13.2 KB)

Regards,
Vinit Mhatre

1 Like
6

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