Post reply

Replace/remove string from a specific word

  • November 2, 2018 at 7:44 am

    #416429

    I have some values in a text column like

    SELECT * FROM Timekeeper_t WHERE User_Name_CH = 'REFINE';

    I would like to remove everything except the table name so the text data will contain only the table name and nothing else. How can I accomplish it?

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • November 2, 2018 at 8:19 am

    #2012192

    Administering Databases - Friday, November 2, 2018 7:44 AM

    I have some values in a text column like

    SELECT * FROM Timekeeper_t WHERE User_Name_CH = 'REFINE';

    I would like to remove everything except the table name so the text data will contain only the table name and nothing else. How can I accomplish it?

    Do all of the entries follow the same, very simple, pattern, or are there some more complex queries in there?
    Can you simply extract the text between FROM and WHERE, for example?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply