How to extract text after a word in power query

[koorosh]

Hello All, How to extract text in a column after a word and a delimiter? For example, I want to extract text after "data." in a column.

key.0.chek.1.data.folder1

Extracting after the "." delimiter does not work, since it has no fixed position.

Regards

[parry2k]

@koorosh sir, you keep on asking multiple questions on the same post, you should follow some general forum principles, and ask as many questions as you want, but keep each question seperate post and whatever question is solved, mark that as an answer.

End of the day, you don't want this one post with TONS of questions. Thank you!

[koorosh]

Ok Sir.  Thank you for the point.

[koorosh]

Meanwhile regarding asterisk symbol , I want all result like the following:

items.0.tags.1.value
items.2.tags.0.value
items.1.tags.2.value

and so on.

[parry2k]

@koorosh I tried and it worked, not sure why you are getting two values:

Here is sample data:

here it is after the filter:

[koorosh]

Thanks . How about with more conditions? For instance filter the records have the following content.

time_file_link, _class tag

[parry2k]

@koorosh add any filter on the column and then change it to this :

Text.Contains([col1], "*.tags.*"

[koorosh]

This code will result
"items.0.tags.0.type" also.
But I need just
"items.*.tags.*.value"

[koorosh]

[parry2k]

@koorosh add a new column in PQ using this M code:

Text.AfterDelimiter([col1],"data.")

[parry2k]

@koorosh why not use "data." as a delimiter if you want to extract after "data"

[koorosh]

How to extract records that contain the following context?

items.*.tags.*.value

[Ritaf1983]

Hi @koorosh 

Can you please share some example of data and the desired result?

[koorosh]

I want to extract text after "data."

[Ahmedx]

Is this what you are looking for?