How to extract characters from a given string?

[Anmolgan]

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).

[Anmolgan · Accepted solution]

@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.

[judspud]

Hi @Anmolgan 

Will the string always be the same length?

If so, you can use the MID function

https://docs.microsoft.com/en-us/dax/mid-function-dax

Hope this helps

Thanks,

George