如何将 AWS 区域/可用区数据格式化为表格? [英] How to format AWS regions/AZs data into table?

问题描述

我正在尝试转换

为什么会发生这种情况，我该如何解决?另外，我可以做些什么来删除诸如 Map Key、Regions、Edge Locations 等的冗余文本?我只需要...(Region)"、AZs:..."和已发布……".

最后，如果可能的话，我该如何放置边缘位置"、AWS 本地区域"?和区域边缘缓存"来自

远非正确

我使用 TRANSPOSE(SPLIT(IMPORTXML(...),";") 来分隔城市，但发生的只是文本可靠、低延迟和高吞吐量的网络连接" 留下了.

在此先感谢您的帮助...

解决方案

针对地区、可用区和推出年份

=query(importxml("https://aws.amazon.com/fr/about-aws/global-infrastructure/regions_az/","//div[@class='lb-rtxt']//p"),"选择 Col1,Col3,Col5,Col7,Col9 其中 Col5 不为空")

或...

=query(importxml("https://aws.amazon.com/about-aws/global-infrastructure/regions_az/?nc1=h_ls","//div[@class='lb-rtxt']//b|//div[@class='lb-rtxt']//i"),"select * where Col1 like 'Launched%' or Col1 like '%Region%' ")

.

I am trying to turn the Region, AZs and Year Launched data on the AWS global page infrastructure into a table with three columns. I was very close when I used the formula

=IMPORTXML("https://aws.amazon.com/about-aws/global-infrastructure/regions_az/","//div[@class='lb-rtxt']//p")

but the table is missing US East (Northern Virginia) Region

Why did this happen and how can I fix it? Also, what can I do to remove the redundant text like Map Key, Regions, Edge Locations, etc.? I only need "...(Region)", "AZs:..." and "Launched ...".

Finally, if possible, how can I put "Edge locations", "AWS Local Zones" and "Regional Edge Caches" from here into their own (three) separate columns? The closest I could get was

=IMPORTXML("https://aws.amazon.com/cloudfront/features/?p=ugi&l=na&whats-new-cloudfront.sort-by=item.additionalFields.postDateTime&whats-new-cloudfront.sort-order=desc","//div[@class='lb-rtxt']//p[1]/text()")

Far from correct

I used TRANSPOSE(SPLIT(IMPORTXML(...),";") to separate the cities but what happened instead was only the text "Reliable, low latency and high throughput network connectivity" remained.

Thanks in advance for any help...

解决方案

For Regions, AZs, and Year Launched

=query(importxml("https://aws.amazon.com/fr/about-aws/global-infrastructure/regions_az/","//div[@class='lb-rtxt']//p"),"select Col1,Col3,Col5,Col7,Col9 where Col5 is not null")

or ...

=query(importxml("https://aws.amazon.com/about-aws/global-infrastructure/regions_az/?nc1=h_ls","//div[@class='lb-rtxt']//b|//div[@class='lb-rtxt']//i"),"select * where Col1 like 'Launched%' or Col1 like '%Region%' ")

.

这篇关于如何将 AWS 区域/可用区数据格式化为表格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！