Hi, Whats the simplest way to convert several cells of text coming into TD via a CSV file to all lower case text values.
FileIn DAT > Evaluate DAT? Then an expression that goes like for all celldata, lower(celldata)?
Hi, Whats the simplest way to convert several cells of text coming into TD via a CSV file to all lower case text values.
FileIn DAT > Evaluate DAT? Then an expression that goes like for all celldata, lower(celldata)?
Perhaps a substitute DAT
I do it with a scriptDAT. try this:
lowerscript.toe (4.1 KB)
this great @drmbt, it works great on my end - and i’ve ended up using .title instead of .lower for title case. thank you!
@jreodica the evaluate DAT you mentioned in your first post also works