Forum Discussion
Rnaval
Post Partisan
Post PartisanNeed help with new column based on a search string
I have a field with multiple values. Is there a way for me to search for a specific string and capture the value listed after the string and put it in a new column?
Here's an example...I want to capture the value after Scanner name, in this case "B&T ITS VN-QM-HC Weekly" and create a new column with just this value.
hi Rnaval
> Load your data into Power BI.
>Go to Transform Data → this opens Power Query
>Select the column that contains your text field.
- Use Add Column → Extract → Text After Delimiter.
- Set the delimiter as "Scan Name"
- This will create a new column with everything that comes after "Scan Name"
- If you only want the first word/phrase (like"B&T ITS VN-QM-HC Weekly") , you can further split by another delimiter (for example, newline, comma, or semicolon depending on how your field is structured).
Regards.
Ritesh
2 Replies
- ribisht17
Super User
hi Rnaval
> Load your data into Power BI.
>Go to Transform Data → this opens Power Query
>Select the column that contains your text field.
- Use Add Column → Extract → Text After Delimiter.
- Set the delimiter as "Scan Name"
- This will create a new column with everything that comes after "Scan Name"
- If you only want the first word/phrase (like"B&T ITS VN-QM-HC Weekly") , you can further split by another delimiter (for example, newline, comma, or semicolon depending on how your field is structured).
Regards.
Ritesh
RnavalThank you, that was quite easy to do.