Dear All,
I am having issue with extracting the data, Please help me with the following question -
My data is the text file and i would like to extract the data from it,
is there any way to search the keywords and then extract the next value? Below is the sample input and the sample output
Input -
Field |
A 1 B 2 C 3 |
Apple 99 DONUT 165.00 TAXI |
RELY 12 Next trip 664 @ 99% 146 |
^ All of Ear 1,000.00 |
Output
Field | Value |
A | 1 |
B | 2 |
C | 3 |
Apple | 99 |
DONUT | 165.00 |
RELY | 12 |
Ear | 1,000.00 |
Appreciate you help,
Thank you in advance
Solved! Go to Solution.
Are you repeating this process multiple times for a minimal amount of data each time or do you have a ton of keyword selectors? It really helps determines how to implement it... Also - it is always a number that follows? I can give you regex to search and select numbers following your keywords but it would be specifically tuned for these keywords and these examples.
Hi @apathetichell thanks a lot for reply, yeah it will always be a number after the keyword and i will be having a few keywords similar to the sample above,
Thank you so much
Thanks a lot for the wonderful workflow but if i have Input like this and we want to extract the next value after the keyword, how we can do it please?
ID Number: AXXX12B |
Date . 05 Jun 2020 |
YEAR OF ATTENDENCE 1982 |
apple. Class (APPLE) 10.00 by 05 Jul 2020 |
output -
ID Number | Date | YEAR OF ATTENDENCE | Class (APPLE) | by |
AXXX12B | 05 Jun 2020 | 1982 | 10.00 | 05 Jul 2020 |
Thank you in advance
Thanks a lot for the wonderful workflow but if i have Input like this and we want to extract the next value after the keyword, how we can do it please?
ID Number: AXXX12B |
Date . 05 Jun 2020 |
YEAR OF ATTENDENCE 1982 |
apple. Class (APPLE) 10.00 by 05 Jul 2020 |
output -
ID Number | Date | YEAR OF ATTENDENCE | Class (APPLE) | by |
AXXX12B | 05 Jun 2020 | 1982 | 10.00 | 05 Jul 2020 |
Thank you in advance
Hi @Ekta,
your original data was considerably less structured than this and relied upon keywords searching the same set of data and then extracting - this should be more straight forward but I'm unsure if the search terms are manually entered, come from a different datasource or static? This drastically changes how the workflow is set up.
@ArtApa Thanks so much for the workflow, it worked perfectly fine:)