Skip to main content
  • EN

Hi,

 

I'm new on/to FME. How to check CVS header spelling. Example I have one CSV file and it contain name and location as it header. Header should be spell as name and location, if it spell as Name/NAME or Location/LOCATION it will return false/incorrect.

 

Thank you.

Read the CSV with Field Names Line set to None. Sample the first line, test the attribute values. If the names in the first line pass the test, continue processing the CSV. See possible workflow below.

Or maybe you can use a BulkAttributeRenamer to change the case of the attribute names to lowercase.

CSV Header sample workspace

Read the CSV with Field Names Line set to None. Sample the first line, test the attribute values. If the names in the first line pass the test, continue processing the CSV. See possible workflow below.

Or maybe you can use a BulkAttributeRenamer to change the case of the attribute names to lowercase.

CSV Header sample workspace

Thank you @geomancer

Reply


Community Stats

30,168
Posts
114,527
Replies
37,825
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.