How to transform CSV to Turtle (.ttl)

Have a look at the StringConcatenator. You can then use the example above as a template and insert the appropriate values into it

 <http://example.com/@Value(id)> rdf:type owl:NamedIndividual ;
                 a:name "@Value(name)" ;
                 a:date "@Value(date)";
                  a:ref "http://example.com/@Value(Val1)",
                             "http://example.com/@Value(Val2)" .

 <http://example.com/@Value(id)> rdf:type owl:NamedIndividual ;
                 a:name "@Value(name)" ;
                 a:date "@Value(date)";
                  a:ref "http://example.com/@Value(Val1)",
                             "http://example.com/@Value(Val2)" .

Thanks - that is very helpful and I got most of it to work...

Two edge cases:

• can I detect an empty value (ie no value between the commas) and ignore the new line?
• how can I check if a value like "Foo, Bar" has a comma in-between and create two output lines with each value?

@riannella​ I really like @hkingsbury​ 's approach - very elegant. An alternative might be to use AttributeExploder that will give you name/value pairs which you could manipulate into the Turtle format. AttributeExploder might be more flexible if your CSV attributes change with each dataset.

Can you provide some example data? Often in these situations its best to look at specific data rather than speculate the exact format and behavior of it

Hi, consider this data:

12345, Fred, 2020-01-01, Foo
12346, Mary, 2020-01-01, "Foo, Bar, Me"
12347, Bill,,

The first line would produce:

<http://example.com/12345> rdf:type owl:NamedIndividual ;
                 a:name "Fred" ;
                 a:date "2020-01-01" ;
                  a:ref "http://example.com/Foo" .

The second line:

<http://example.com/12346> rdf:type owl:NamedIndividual ;
                 a:name "Fred" ;
                 a:date "2020-01-01" ;
                  a:ref "http://example.com/Foo" ,
                          "http://example.com/Bar", 
                          "http://example.com/Me" .

And the third:

<http://example.com/12347> rdf:type owl:NamedIndividual ;
                 a:name "Fred" .

Thanks!

I also have cases where text like Fred, Mary, and Bill may already be in quotes ("Fred") - so I think I need to remove all quotes (if they are there) then re-add them to be sure.

Many Thanks - that is brilliant !!😀