Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago
Solved

How to extract characters from a given string?

Hi I want to remove first 3 values from a string and last 4 values from a same string and cocatenate those is that possible, for example I have 2100321034432 (I want to remove 210 and 4432 so I should only have 032103).

Need Help
  • Anmolgan's avatar
    Anmolgan
    6 years ago

    judspud Thanks for the reply, but I used query editor add column pane, to extract mid 5 digits, with specifying start and number of values to extract.