Forum Discussion
Fetch text in cell and return corresponding value
Oke. I think you might want to try to add a column to your table in Query Editor. You can type it in the Advanced Editor, or you can use the "Add column > extract > text between delimiters".
In the advanced editor it will look like this:#"Inserted Text Between Delimiters" = Table.AddColumn(#"Changed Type", "Text Between Delimiters", each Text.BetweenDelimiters([Column1], "INMETRO Ordinance No.", ","), type text), #"Changed Type1" = Table.TransformColumnTypes(#"Inserted Text Between Delimiters",{{"Text Between Delimiters", Int64.Type}})In UI something like this:
Hope this will help you!
Helper III'm not totally sure what you are looking for. Do you want the number that is at the end of column B and place that in column A?
- I am looking for the entire string (INMETRO Ordinance No. 371) in the text, for example: "IEC 60335-1: 2010; INMETRO Ordinance No. 371, of December 29, 2009; IEC 60335-2-23: 2003 + A1: 2008 + A2: 2012" When you find this string, return only the final number, in this case 371.
- danielkrol
Oke. I think you might want to try to add a column to your table in Query Editor. You can type it in the Advanced Editor, or you can use the "Add column > extract > text between delimiters".
In the advanced editor it will look like this:#"Inserted Text Between Delimiters" = Table.AddColumn(#"Changed Type", "Text Between Delimiters", each Text.BetweenDelimiters([Column1], "INMETRO Ordinance No.", ","), type text), #"Changed Type1" = Table.TransformColumnTypes(#"Inserted Text Between Delimiters",{{"Text Between Delimiters", Int64.Type}})In UI something like this:
Hope this will help you!
danielkrol Wow, thank you. I didn't remember that function. Sorry, I'm quite new to Power BI.
I have only two problem, sometimes the employee did not insert the comma after the Ordinance number:
We also have the problem that, there are cases that for a single process there are complementary ordinances that sometimes come before the main ordinance that I am looking for, for example:
But I can use the replacement tool for that, I believe.
