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 IIOke. 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.
- danielkrol
MatiasSousa you can try adding a space after your "no" sign, so your first delimiter is "no ", and then your second delimiter is also a space (" "). You then need to insert a step to get rid of the comma in some cases. You can use the replace function for that.
Hope you can get it to work!