Skip to main content
  • EN

Hello,

I need to retrieve the value of a column header in a CSV file. The column header contains the ID of a meter I need to use as an insert into a database. Unfortunately I can't use a filepathreader as the id filed isn't included.

 

Any idea how I might do this? I have attached a test file. The value I need to extract from the column header is the string after the undescore.

If you read the csv without a field names line so your attributes are returned as col0 and col1, the first record will contain the value in col1 and you can use a string searcher with some regex to return the value.

Brilliant - thank you!

Reply


Community Stats

30,112
Posts
114,305
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.