Help

FIND formula to identify one or many issues in a URL

Topic Labels: Formulas
Solved
Jump to Solution
572 4
cancel
Showing results for 
Search instead for 
Did you mean: 
airballer86
6 - Interface Innovator
6 - Interface Innovator

I am trying to use the find formula to identify one or many issues in a URL

For example in the field Link URL I have two urls; one with one issue and one with multiple issues
https://www.google.com/workin'-late.html
or
http://www.google.com/workin'-late.html

Any help would be appreciated. Here was my first go at it:
IF({Link URL},
IF(FIND("http://", {Link URL}), 'missing https',
IF(FIND("'", {Link URL}), 'remove apostrophe',
IF(
FIND("http://", {Link URL}),
FIND("'", {Link URL})
, 'missing https and remove apostrophe'
)
)
)
)

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Sorry, I missed that!

NOT() to determine if it's missing.

IF(
  {Link URL},
  IF(
    OR(
      FIND("http://", {Link URL}),
      NOT(FIND("https://", {Link URL}))
    ),
    "missing https, "
  ) &
  IF(
    FIND("'", {Link URL}),
    'remove apostrophe, '
  )
)

 

See Solution in Thread

4 Replies 4
Sho
11 - Venus
11 - Venus

It's easy if it's a list of words, but when you try to connect them with AND, it becomes difficult!

IF(
  {Link URL},
  IF(
    FIND("http://", {Link URL}),
    IF(
      FIND("'", {Link URL}),
      'missing https and remove apostrophe',
      'missing https'
    ),
    IF(
      FIND("'", {Link URL}),
      'remove apostrophe'
    )
  )
)

If you plan to add more conditions, this could be a better one.

IF(
  {Link URL},
  IF(
    FIND("http://", {Link URL}),
    'missing https, '
  )&
  IF(
    FIND("'", {Link URL}),
    'remove apostrophe, '
  )
)

 

airballer86
6 - Interface Innovator
6 - Interface Innovator

@Sho 

Your second option is perfect! One more thing, how would I identify something missing; e.g., the URL starts with www.google..com (missing the https://) 

 

IF(
  {Link URL},
  IF(
    FIND("http://", {Link URL}),
    'missing https, '
  )&
  IF(
    FIND("'", {Link URL}),
    'remove apostrophe, '
  )&
  IF(
    FIND("NO https://", {Link URL}),
    'missing https, '
  )
)
airballer86
6 - Interface Innovator
6 - Interface Innovator

@Sho how would I identify something missing; e.g., the URL starts with www.google..com (missing the https://) 

IF(
  {Link URL},
  IF(
    FIND("http://", {Link URL}),
    'missing https, '
  )&
  IF(
    FIND("'", {Link URL}),
    'remove apostrophe, '
  )&
  IF(
    FIND("NO https://", {Link URL}),
    'missing https, '
  )
)
Sho
11 - Venus
11 - Venus

Sorry, I missed that!

NOT() to determine if it's missing.

IF(
  {Link URL},
  IF(
    OR(
      FIND("http://", {Link URL}),
      NOT(FIND("https://", {Link URL}))
    ),
    "missing https, "
  ) &
  IF(
    FIND("'", {Link URL}),
    'remove apostrophe, '
  )
)