Delete a character



  • How can I delete just the “0” at the begining of a line ?
    Example:
    0002345;XXXXXX;85
    0122445;XXXXXX;96.85

    Result wanted:
    2345;XXXXXX;85
    122445;XXXXXX;96.85

    Thanks.



  • find what = ^0+
    replace with = `` (empty)
    make sure you’re in regular expression mode


    FYI: if you have further regex needs, study this FAQ and the documentation it points to. Before asking a new regex question, understand that many of us will expect you to show what data you have (exactly), what data you want (exactly), what regex you already tried (to show that you’re showing effort), why you thought that regex would work (to prove it wasn’t just something randomly typed), and what data you’re getting with an explanation of why that result is wrong. When you show that effort, you’ll see us bend over backword to get things working for you. If you need help formatting the data so that the forum doesn’t mangle it (so that it shows “exactly”, as I said earlier), see this help-with-markdown post, where @Scott-Sumner gives a great summary of how to use Markdown for this forum’s needs.


Log in to reply