URGENT: add quotation marks to fields that contain commas

[Landings_Holida]

I have an urgent need to find data cells that contain commas and enclose the data with quotation marks
A single table, with identifiable columns where needed.

[Bill_French]

A little dated, but this might help -

Field Tweaker - Script Block for In-place Transformations Show and tell

After importing data, it’s not uncommon to want to clean up and normalize data values, especially text fields that may have all types of inconsistencies. Unfortunately, Airtable doesn’t support in-place transformations where formulas can be applied to modify the field contents of all cells. This is where the Field Tweaker script block can help. It supports in-place text transformations including upper case, lower case, and title case modifications across all records for select fields. The scrip…

[kuovonne]

Would a formula field for each column work?

IF(
    FIND(",", {field name}),
    '"' & {field name} & '"',
    {field name}
)

If some already have quote marks as expected, and some have quote marks that need escaping, you might need something a bit more complicated.

IF(
   AND(
        FIND(",", {field name}),
        OR(
            LEFT({field name}, 1) != '"',
            RIGHT({field name}, 1) != '"'
        )
    ),
    CONCATENATE(
        '"',
        SUBSTITUTE({field name}, '"', '""'),
        '"'
    ),
    {field name}
)

[Landings_Holida]

HOORAY!!! First example should do it. Might I ask how it could be executed for all cells in a column? I only have about 8 columns and could do 'em one at a time.

Many thanks!!!

[Landings_Holida]

I get a circular ref error with
IF( FIND(",", {Favorite Characters}), ‘"’ & {Favorite Characters} & ‘"’, {Favorite Characters} )

here’s the test data in the field Batman, Robin and Starwars

[Landings_Holida]

Oops… same error with this one

IF(
AND(
FIND(",", {Favorite Characters}),
OR(
LEFT({Favorite Characters}, 1) != ‘"’,
RIGHT({Favorite Characters}, 1) != ‘"’
)
),
CONCATENATE(
‘"’,
SUBSTITUTE({Favorite Characters}, ‘"’, ‘""’),
‘"’
),
{Favorite Characters}
)

[kuovonne]

You need to create a new formula field.

[Landings_Holida]

I’ve changed the Favorite Characters from single line text to formula. Do u mean I need another field?

[kuovonne]

Landings_Holiday:

Do u mean I need another field?

Yes. Keep the existing single line text field. Add a new formula field that references the existing field.

[Landings_Holida]

Hmm… since my current fields layout is critical for export CSV, I suppose I could add another field all the way at the end. But then I’d have to copy the " " text back to Favorite Characters field.