Greetings, I tried this in calc (which I am assuming you are using), and it seems to work for what you describe:
[<>""]-@ The interesting thing is that calc changed it afterwards to [<>0]-@;Standard but it still seems to work. I hope this helps. Rémy. Le mercredi 15 mai 2019 à 15:17 -0700, Girvin Herr a écrit : > Greetings, > > I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75). > > I have a database with a text field which may or may not be null. What I > want to do is to prefix a dash "-" before the text if the text field is > not null. At first, I tried this format: > > ;;;"-"@ > > Somewhere, not by me, it got changed to: > > [>0]"";[<0]"";"";"-"@ > > However, this does not work. I get the text when not null, but not the > dash in either case. > > Is there another way to do this? > > Thanks. > > Girvin Herr > > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy