Filter and Merge Multiple CSV file

Help Activities
, ,
1

Dear friends,

I have 4 CSV files. In that 4 files I have some date and I want to remove ,ABC,ABC from that CSV file and write the remaining output to the same sheet again. I have to do this for all the 4 CSV files.

Please help me

2

Hi @hanviprebday

If possible can you share the file and required output.

Regards,

3

24/11/2023|ICI|Division|ABC|ABC this is the CSV file

I want the output like this
24/11/2023|ICI|Division

Sorry i have give commas in my previous post but it’s a pipe seperator

4

Hi @hanviprebday

You can use Replace function.

YourTextVariable.Replace("|ABC|ABC", "")

If possible share your csv file.
Hope it helps!!

5

Hi @hanviprebday ,

here is the sample code.
BlankProcess1.zip (142.3 KB)

6

Could you please sahre yoir sample file?
You can follow steps:
1.read each file to get each data table
2.filter data tale to remove ,ABC,ABC,…
3.write each data to sheet,
loop for 4 file
the index of 2nd-4th data is the 1st bank row of sheet
regards,