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]

@Anand_Designer Read your excel file and the use for each row activity with input getting from read excel file. 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 i…

Split data in excel search in website

Learn Academy Feedback

balupad14 (Balamurugan) May 6, 2020, 12:01pm 6

Hi @Anand_Designer,

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

Regards
Balamurugan.S

Topic		Replies	Views
Split text.in excel column Help excel , activities , question , data_manipulation	12	1774	November 26, 2019
Replace value in Excel Help	3	2760	December 2, 2019
How to remove "PC-F50A" or "\|PC-F50A" or "PC-F50A\|" in input excel Activities excel , activities , studio	6	488	October 13, 2022
Filter data and remove the rows Studio excel , studio	10	820	December 21, 2022
Help with String manipulation - need to remove part of the string Activities excel , activities , studio , question	8	373	December 23, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Split data in excel search in website

Related Topics