Loop all CSV files in a folder the read each files
Posted: 26 May 2022, 23:54
I want to process all CSV files in a certain folder then loop it again to read each CSV files (or make action with it). But this script below don't work.
Hope someone could help. Thanks.
Code: Select all
Sleep 1000
Loop Files, C:\Users\elnicx\OneDrive\Desktop\ProductDBAuto\reviews\*.csv
{
Loop, parse, read, C:\Users\elnicx\OneDrive\Desktop\ProductDBAuto\reviews\%A_LoopFileFullPath%.csv
{
Column1 := StrSplit(A_LoopReadLine, ",").1
Column2 := StrSplit(A_LoopReadLine, ",").2
Column3 := StrSplit(A_LoopReadLine, ",").3
MsgBox, 4, , %Column1% - %Column2% - %Column3%
IfMsgBox, No
break
}
}
return