[SOLVED] Using Delimited Field to Adjust lastname string

Hi,

I have a review website. To prevent reprisals for bad reviews I need to protect the last name of the reviewer. During registration I need to capture the full last name. On the users profile I need the only the last name initial to show. Does anyone know how to do this with a delimited field?

Can't do it with a delimiter field as it's purely HTML and no PHP logic available. You'll need to use incubator project CB Query Field with the below query.

If for some reason your database doesn't support the dummy table DUAL you can use the below.

Thanks for the help. I tried both codes using CB Query Field, but each time the field only outputted a "-". Could it be because my website is in a subdomain and not the main domain?

Domain has nothing to do with it, it's simply a query that grabs the first letter of the lastname. If there is no lastname then it won't do anything. It depends on what your name format is set to within CB > Configuration. It would need to be first and last name or first, middle, and last name display modes. Simply name field would require a more complex query.

Ok my name style in CB Configuration Manager is set to "First and Last Name Field". When a user registers the enter a first and last name, those fields are populated. I also double checked in User Management to make sure first and last names existed in those fields and they do.

I have also created a query field with field name cb_lastinitial and tried the different variations of query code one at a time, into the Field-specific Parameters text area with mode Internal selected. The cb_lastinitial field is set to published. The CB Query Field plugin is installed and also published.

Do you know of anything else I can try?

The second query is what you should likely be using then as it'll ignore permissions or anything of the sort. The only other option is to pull name directly from _users, break it into first/middle/last then grab the first letter of the last name which is a much more complex query. The second query I have confirmed working fine please ensure you've directly copy and pasted it to the fields configuration. Please also ensure your host is using at minimum MYSQL 5.0.