Hi @umutcankurt , this sounds like something that is going to have to be specifically tailored to the type of text that you have so I think it would be beneficial if you could upload some sample text and a list of “reference words” along with an indication of the various date formats that you might expect to see in your text.
This to me is the kind of task that is quite tricky using bespoke “rules” because you need to write regex or string manipulation to be able to cover all conceivable free text inputs but we can expect that an AI interface using a large language model would be able to provide good results with little effort (from us).
Hi; @takbb test1.csv (49.3 KB)
The test data file is attached. 1 word I’m looking for is "Time-limit for tender : " I want to get the date part after the word, in a different column
In the Table Creator at the lower left, there are a number of keywords/expressions:
These are keys to look for in the text. I’m assuming that each appears on its own line, as that is how it appears to be presented in the sample file.
The workflow looks for any of these and returns all of the text which follows each of those key expressions. It then pivots the result so that when found, the different values appear in their own column.
I don’t know what you then want to do with the data, but you may need to perform further transformations on the results to return the data in a form that you need.
@umutcankurt , if the sample data you uploaded was “real” data rather than purely test data, please delete your upload of the test1.csv file, and if unable, please flag it and request it be deleted.