Referenceing cells by header column name

Hi, I am a new user so sorry if this is clear to others.

I have bank statements in CSV format, which have a “variable” format, i.e. different banks use different layouts.

Is there a way to load a “template” so that I know which columns are available when I load the CSV file. Also can I reference a cell by something like AccountNumber / Row Number.

Hope this makes some sense

Thanks

Hi,

You could read the first row of your CSV file in order to obtain the header names.

After that, you can use this information to select which column you want to read.

I hope this helps,

Regards,
Mario

Thanks for the info.
Will give it a try