Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

FIND formula to identify one or many issues in a URL

Topic Labels: Formulas
Solved
Jump to Solution
1768 4
cancel
Showing results for 
Search instead for 
Did you mean: 
airballer86
7 - App Architect
7 - App Architect

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
7 - App Architect
7 - App Architect

@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
7 - App Architect
7 - App Architect

@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, '
  )
)