Forum Discussion
Split text based on character
Hi, I have a text value that I want to be able to split in two different places. The value looks like the following: XXXX_YY1234_V1_AA I am trying to extract just the "YY1234" part. I would d...
Tahreem24
Super User
Super UserAnonymous ,
You can get your result using Power Query setting.
Go to Power Query Editor --> Select your column --> right click on it --> select Split by delimiter --> choose custom option and type "_" underscore and hit okay.
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.