CSV, Regular Expression, and Tuple String Items

[atlauren]

Greetings from 2025! This is exactly what I’m looking for!

@JasonWalker

I ended up with the regex

((^|,)((%22([^%22]|%22%22)*%22)|[^%22,]*)(,|$))((%22([^%22]|%22%22)*%22)|[^,]*)(,|$)

[snip]

  /*  Format the results into Tuple Strings by escaping them - enclosing each item in "( )" and separating by ", "  -- so an embedded comma doesn't resolve as an excess tuple string item */

[snip]

Put into practice, I can retrieve all of the asset tag numbers from a CSV of 8,249 lines in about a half-second:

    q:  number of tuple string items 0 of (("( " & concatenation " ), ( " of parenthesized parts 3 of matches (regex "((^|,)((%22([^%22]|%22%22)*%22)|[^%22,]*)(,|$))((%22([^%22]|%22%22)*%22)|[^,]*)(,|$)") of it & " )")) of (lines of file "c:\temp\computers.csv" )

See application over here.