Order # | Purchase Date | Return Date |
AAA1 | 2/8/2020 | 5/8/2020 |
B21 | 2/8/2021 | 6/8/2021 |
C12 | 2/8/2022 | 3/8/2022 |
DDD1 | 2/8/2023 | 7/8/2023 |
EEF3 | 2/8/2024 | 8/8/2024 |
chunk(
split(
replace(
replace(
body('Html_to_text'),
'Order # Purchase Date Return Date ',
''
),
decodeUriComponent('%0A'),
' '
),
' '
),
3
)
item()[0]
item()[1]
item()[2]
slice(
outputs('Compose'),
indexOf(
outputs('Compose'),
'<table'
),
add(
indexOf(
outputs('Compose'),
'</table>'
),
8
)
)
skip(
xpath(
xml(outputs('Compose')),
'//tbody/tr'
),
1
)
trim(
xpath(
item(),
'string(//td[1])'
)
)
trim(
xpath(
item(),
'string(//td[2])'
)
)
trim(
xpath(
item(),
'string(//td[3])'
)
)