MySQ

How do I separate the Hypertext Name and URL Address of a Website field in a query?
Looks like the delimiter is |*| and I don't see that on the Delimiter options on the Query Display tab using single column.
Is there an SQL Select command or some way I can separate these to show as separate query results (one for Hypertext, one for URL address)?

Use SQL and split it. See the below for MySQL string function documentation. Easiest approach is probably just a REGEXP. You could also find location of the |*| delimiter then use SUBSTR, LTRIM, etc.. usages.

dev.mysql.com/doc/refman/5.7/en/string-functions.html

I've tried and failed. I assumed the SQL guery goes in the Query box, but what do I put in the row to display?

BTW - the SQL link is great, but only for those who really know SQL - I do not.

Any help from anyone would be greatly appreciated.

I cannot help you with writing custom SQL without a Business Membership , sorry. That fields purpose is to output the results of a custom database query. If you don't know how to write database queries it's going to be difficult for you to use it.

Why exactly are you needing to do query for user field data? You should be able to just output fields normally using substitutions.

Thanks for your reply.

If I do get the SQL written, I still am not sure what goes in the Display's Row box.
Normally I would do [column_cb_urlofwebsite], but does that work when SQL statement is separating the field?

I have three groups, Staff that can edit profiles.
Client and Carriers are other the other 2 groups.
The Clients and Carriers are maintained by Staff.
Staff needs to be able to see Carrier info in a Client's profile, but not be able to edit it while in Client's profile. But can edit it in Carrier's profile.
So a query of the Carrier's field shown in the Client's profile works great.
I need it for the Carrier's Phones, URL and Street Addresses.
For Phones and Addresses, I create separate fields for labels.
Had done URL with label field also in past, but with option to add Hypertext label to the URL field, I thought I'd be able to do away with a separate URL label.

I got it figured out.