# Extract information from a document and use the information to select several variables from a predefined array **URL:** \ **Category:** Ask for Help\ **Created:** [July 1, 2024, 6:20am UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512 "2024-07-01T06:20:07Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![0123ren](https://avatars.discourse-cdn.com/v4/letter/0/a4c791/32.png) [@0123ren](https://community.glideapps.com/u/0123ren)\ **Post date:** [July 1, 2024, 6:20am UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/1 "2024-07-01T06:20:07Z")
If a user uploads a CV for instance, I would then like to extract their key skills from that CV, review it against a predefined set of skills and then save this information in a column. For example, one of the extracted skills might be ‘Managing Projects’, I would like to use my predefined list to populate this users skills with ‘Project Management’. I think this can be done with Text to Choice in the AI category, but this one has one choice, I would like to list all skills. Can someone direct me ass to how this could be accomplished. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 1, 2024, 1:59pm UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/2 "2024-07-01T13:59:12Z")
So you want to extract the skills listed in the CV, then convert it to a standardized list of skills? ---
**Author:** ![0123ren](https://avatars.discourse-cdn.com/v4/letter/0/a4c791/32.png) [@0123ren](https://community.glideapps.com/u/0123ren)\ **Post date:** [July 1, 2024, 2:27pm UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/3 "2024-07-01T14:27:48Z")
Correct, I’m trying to keep the naming convention of the skills the same, so I think there would need to be some AI component that could translate how the skills are presented in the CV and convert them to those skills listed in my database of skills. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 2, 2024, 1:23am UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/4 "2024-07-02T01:23:26Z")
My best guess is: - Extracting the text from the doc. - One AI column to extract the “skills” from the text above. - Another AI column to input the extracted skills, tell the AI about your standardized list, and tell it to output a standardized list from the extracted skills. ---
**Author:** ![0123ren](https://avatars.discourse-cdn.com/v4/letter/0/a4c791/32.png) [@0123ren](https://community.glideapps.com/u/0123ren)\ **Post date:** [July 2, 2024, 5:11am UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/5 "2024-07-02T05:11:02Z")
Ill give that a whirl and report back, thanks for your assistance! ---
**Author:** ![0123ren](https://avatars.discourse-cdn.com/v4/letter/0/a4c791/32.png) [@0123ren](https://community.glideapps.com/u/0123ren)\ **Post date:** [July 2, 2024, 1:08pm UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/6 "2024-07-02T13:08:14Z")
Managed this by combining the text extracted from the CV with the list of skills that I was trying to select from. I then created a JSON based upon the extracted text and this combined list, with the instruction to the AI model to only use skills from the list within parenthesis. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a5acccf0daed4c7dde5bab2aab822b06d8a18171.png) Thanks again for your help. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 9, 2024, 1:08pm UTC](https://community.glideapps.com/t/extract-information-from-a-document-and-use-the-information-to-select-several-variables-from-a-predefined-array/74512/7 "2024-07-09T13:08:58Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.