sir can u explain me what did u in that sample process coz it remove date also and actually i want that date in that excel and want to remove special excretion
Hi @swanand_deshmukh,
in method which I have used for this purpose Remove Range has inputs which is starting index and end index which I wanted to remove (you can check that print screen from Notepad++ where you can see special characters and why it is 20).
You can put set up to remove range from 0 to 16 then apply remove range for 2 to 3 because first remove range will clean data from ranges 0 to 16 then index will be moved where 0 index will be your date, 1 index will be colon character, 2 index will be ‘cr’ and 3 index will be ‘LF’, explained in this image:
Ok i got it but if i want to remove unwanted specific csv cell data like for example,
in above image i want to remove second remove range i.e. date and i want before second remove range data and after remove range data so how can we do it.