This line has a couple big problems:
Code: Select all
Loop, parse, read, C:\Users\elnicx\OneDrive\Desktop\ProductDBAuto\reviews\%A_LoopFileFullPath%.csv
There is no such thing as
Loop, Parse, Read. What you need to do first is read the file contents into a variable using
FileRead. Then you would parse them if that’s what you want to do.
This doesn’t make sense as a file path:
C:\Users\elnicx\OneDrive\Desktop\ProductDBAuto\reviews\%A_LoopFileFullPath%.csv
A_LoopFileFullPath is already a full path to the file (hence the name) including the full directory path and the .csv extension. So you just tacked on the path to the beginning and you tacked on the extension to the end of a file path that already included both of those things.
Depending on what’s inside your .csv files, you would then parse it on the line feeds to break it up into individual lines, then you can split it by the commas if you want, although it’s safer to use another parsing loop that uses “CSV” as the parsing criterion.