Skip to main content
Solved

How to remove quotes in IF formula

  • July 26, 2023
  • 2 replies
  • 32 views
Dgmknzgrl
Forum|alt.badge.img+7

Hi all,

I have read up that Airtable inserts double quotes if there are commas in the contents of the array, and I have seen reference to removing them by using either Substitute or Regex_Replace, but I have an IF statement and no idea how/where to put either to make it work (I'm new to formulas and they are def not my strong suit!)

This is my formula:

 

 
IF({Inspection}=BLANK(),{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")")
 
Which gets me:
 
"A11.05/003a Joanna Staniszkis (Artist), Marta W. Suchy (Artist); Summer Kites" (Damage Inspection 2023-07-26)
 
If anyone could help, I'd appreciate it much. TIA!
 

Best answer by Alexey_Gusev

Hi,
You can forget BLANK() in Airtable and use just IF(Inspection, Art&....rest_of_your_formula
You can omit brackets for one-word field names, but some users prefer to use them for all, to mark fields.
If you want to get your output without quotes, wrap your formula into substitute ( " to nothing):

SUBSTITUTE( IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")") '"','')

 

2 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • Answer
  • July 26, 2023

Hi,
You can forget BLANK() in Airtable and use just IF(Inspection, Art&....rest_of_your_formula
You can omit brackets for one-word field names, but some users prefer to use them for all, to mark fields.
If you want to get your output without quotes, wrap your formula into substitute ( " to nothing):

SUBSTITUTE( IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")") '"','')

 

Dgmknzgrl
Forum|alt.badge.img+7
  • Dgmknzgrl
  • Author
  • Participating Frequently
  • July 27, 2023

Hi,
You can forget BLANK() in Airtable and use just IF(Inspection, Art&....rest_of_your_formula
You can omit brackets for one-word field names, but some users prefer to use them for all, to mark fields.
If you want to get your output without quotes, wrap your formula into substitute ( " to nothing):

SUBSTITUTE( IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")") '"','')

 


Thanks much Alexey!

There was a comma missing from the end, but I figured it out (in red).

And now I can use the same formula to fix some other errors I've come across (extra spaces in things), so I'm very grateful, thanks again!

SUBSTITUTE(

IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")") , '"','')

 

Alexey_Gusev
Terms & ConditionsAccessibility statement