I have a series of records in a text file and want to pull out specific properties using a Microsoft Flow.
my data looks like this
"username": "CA001196",
"first_name": "Deion",
"last_name": "Branch"
When I use either of these expressions alone matches are returned. but when I use them together, the results are no matches.
"username":\s(?.+|),
"first_name":\s(?<first_name>.+|)
Hello Harold!
Could you share screenshots of your flow configuration (all actions are open so that I could reproduce it) and of the issue itself?
this is a sample of the data
"3": {
"employee_id": "xxxxx1",
"username": "xxxx5261",
"created_at": "2021-07-22 08:48:50",
"description_of_achievement": "",
"id": "3294",
"type": "peer",
"image": "/asset/848/v=1618420903",
"title": "Act Like an Owner",
"blurb": from your peers to get things done ",
"updated_at": "2021-07-22 08:48:51",
"first_name": "Julian",
"last_name": "Edelman"
},
"4": {
"employee_id": "xxxxx2",
"username": "xxxx196",
"created_at": "2021-07-22 08:50:13",
"description_of_achievement": "",
"id": "3295",
"type": "peer",
"image": "/asset/851/v=1618422191",
"title": "Innovate",
"blurb": "base is taken care of always !",
"updated_at": "2021-07-22 08:50:14",
"first_name": "Deion",
"last_name": "Branch"
}
Hello @haroldbk,
We would recommend you to use Regex Hero tool to test your expressions. It supports the same syntax as the Regular expression match action.
Best regards,
Petr
Plumsail team