Query Column "Display format" Examples

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
UnionSystems
Posts: 197
Joined: Fri Jun 17, 2016 7:10 am
Location: Brisbane Australia
Contact:
Contact UnionSystems

Query Column "Display format" Examples

Post by UnionSystems »

What can be put into a Query column "Display format" field. For example we have a 10 character Plain Text column that stores phone numbers like 0212341234 and we would like to display them in a query column as 02 1234 1234
Attachments
Display format
Display format
QueryDisplayFormat.png (124.07 KiB) Viewed 3258 times
AWS Linux, Windows Server, AIM 8.4 & 8.6
Top
customaware
Posts: 2405
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Query Column "Display format" Examples

Post by customaware »

I haven't used it for text or numbers and don't know how... maybe regex.

I use it a lot for dates ddd dd/MM/yy HH:mm to show the Day of the Week at the front
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Top
Post Reply

Return to “General discussion and questions about Aware IM”