I have a list of files name under one field called "attachment" and I would like to split this string into multiple rows by file names. I tried split/makemv method but it was unsuccessful.. really appreciate any tips on separating this string by file. Thank you
For example:
Raw output: "image001.png Project_Preference_crosstab (3).csv GC_Preferences - 8 Oct.xlsx GC updated skills with ratings - 30 Sep 2021.xlsx Skill_Details_-_Base_crosstab (3).csv AP Talent list - 30 Sep 2021.xlsx UCD_Skills_Compliance_Details_crosstab (2).csv"
I would like to see:
image001.png
Project_Preference_crosstab (3).csv GC_Preferences - 8 Oct.xlsx
GC updated skills with ratings - 30 Sep 2021.xlsx
Skill_Details_-_Base_crosstab (3).csv
AP Talent list - 30 Sep 2021.xlsx
UCD_Skills_Compliance_Details_crosstab (2).csv
| rex max_match=0 field=output "(?<file>.*?\.(csv|xlsx|png|))\s?"
| mvexpand file
| rex max_match=0 field=output "(?<file>.*?\.(csv|xlsx|png|))\s?"
| mvexpand file
This works so well!!!! Thank you so much! ❤️