Split data in excel search in website

Learn Academy Feedback
1

hi,
i have input data in F column is Item Codes in that when data come like this CIS-C9300-DNA-P-24-3Y to remove “CIS-” take remain Data like C9300-DNA-P-24-3Y

mean where ever start with CIS have to remove CIS to filter this data…

can any body help me ?

image
image1366×768 70.7 KB

2

@Anand_Designer Read your excel file and the use for each row activity with input getting from read excel file.

  1. use if condition to check the whether column F value starts with CIS inside for each row activity.
    row(5).toString.StartsWith(“CIS”) as condition.

instead of 5 u can use column name in double quotes.

if condition is true, then use below assign statement otherwise do nothing.

row(5)=row(5).ToString.Replace(“CIS-”,“”)

after for foreach write datatable back to same excel.

1 Like
3

image
image908×568 19.5 KB

4

hi @Petar_Soce
i tried your steps but data Doesn’t filter… not remove CIS.
please look into
filter data.zip (56.8 KB)

5

Check the below file. After execution is done, check the output panel for the final value. You can then write it to the particular column.
filter data using substring.zip (51.9 KB)

6

Hi @Anand_Designer,

you can use the find and replace in excel using the below activity.

Regards
Balamurugan.S

7

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