Skip to main content
Question

Check CVS Header Spelling


Forum|alt.badge.img

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.

2 replies

geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • November 2, 2021

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


Forum|alt.badge.img
geomancer wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings