Skip to main content
Solved

FIND formula to identify one or many issues in a URL

  • October 19, 2023
  • 4 replies
  • 38 views
airballer86
Forum|alt.badge.img+18

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

Best answer by Sho

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

 

4 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • 560 replies
  • October 19, 2023

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
Forum|alt.badge.img+18
  • airballer86
  • Author
  • Known Participant
  • 48 replies
  • October 21, 2023

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

 


@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
Forum|alt.badge.img+18
  • airballer86
  • Author
  • Known Participant
  • 48 replies
  • November 1, 2023

@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, ' ) )
S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • 560 replies
  • Answer
  • November 1, 2023

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

 


Terms & ConditionsAccessibility statement