Line Break in DMRID.CSV

[KA1CM]

Hi all, I'm trying to modify the user.csv downloaded from radioid.net. What I want to archive is to have the first of the two line detailed showing only Firstname, and then the second line showing City State Country. For example
----------
VE3THW

Wayne
Toronto ON CAN
------------

to be able to do this I need to insert a line break (\n , LF ,VT, FF, CR, NEL, LS, <br>, etc) between the first name and the city. My question is, how to do this in CSV format. I've tried replacing the LAST_NAME column with "\n" and the csv file looks like this.

RADIO_ID,CALLSIGN,FIRST_NAME,LAST_NAME,CITY,STATE,COUNTRY
1023001,VE3THW,Wayne,\n,Toronto,ON,CAN
1023002,VA3ECM,Mathieu,\n,Ottawa-Hull,QC,CAN
1023003,VE3QC,Guy,\n,Gloucester,ON,CAN
1023007,VA3BOC,Hans Juergen,\n,Cornwall,ON,CAN
1023008,VE3JMR,Mark,\n,Niagara Falls,ON,CAN
1023009,VA3AMO,Rolando,\n,Scarborough,ON,CAN
1023010,VA3AMO,Rolando,\n,Scarborough,ON,CAN
1023014,VA3DB,Diane,\n,Nepean,ON,CAN

Screenshot 2024-04-08 214930.png (154.55 KiB) Viewed 197 times

But it doesn't work.

any suggestions?

[VK3KYY]

Firmware does not support and form line breaks for multiple reasons, including the custom character set and the data compression for DMR ID text data

[KA1CM]

Firmware does not support and form line breaks for multiple reasons, including the custom character set and the data compression for DMR ID text data

Thank you, Roger.I have put the Last name column back and tweaked the database as best as I can, at least for the US, Canada, and the UK (GB).
Thank you for all the wonderful work.

us.jpg (90.91 KiB) Viewed 154 times

ca.jpg (89.99 KiB) Viewed 154 times

gb.jpg (91.8 KiB) Viewed 154 times

[KA1CM]

The workaround is here viewtopic.php?f=7&t=3997