IF(
CONTAINS(
RIGHT(
Website,
LEN(Website) -
IF(BEGINS(Website, "https://www."), 12,
IF(BEGINS(Website, "http://www."), 11,
IF(BEGINS(Website, "https://"), 8,
IF(BEGINS(Website, "http://"), 7,
IF(BEGINS(Website, "www."), 4, 0)))))
),
"/"
),
LEFT(
RIGHT(
Website,
LEN(Website) -
IF(BEGINS(Website, "https://www."), 12,
IF(BEGINS(Website, "http://www."), 11,
IF(BEGINS(Website, "https://"), 8,
IF(BEGINS(Website, "http://"), 7,
IF(BEGINS(Website, "www."), 4, 0)))))
),
FIND(
"/",
RIGHT(
Website,
LEN(Website) -
IF(BEGINS(Website, "https://www."), 12,
IF(BEGINS(Website, "http://www."), 11,
IF(BEGINS(Website, "https://"), 8,
IF(BEGINS(Website, "http://"), 7,
IF(BEGINS(Website, "www."), 4, 0)))))
),
1
) - 1
),
RIGHT(
Website,
LEN(Website) -
IF(BEGINS(Website, "https://www."), 12,
IF(BEGINS(Website, "http://www."), 11,
IF(BEGINS(Website, "https://"), 8,
IF(BEGINS(Website, "http://"), 7,
IF(BEGINS(Website, "www."), 4, 0)))))
)
)