Forum Discussion
Solved
Need 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 ...
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
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
Thank you, that was quite easy to do.