UiPath StudioX 初学者向け メール本文から注文IDを抽出する方法

例題

例えばこのような受領書をメールとし受け取り、その中にある受領番号を抽出したいとします。

 

Studioなら正規表現とMatchesアクティビティで一発だが……

(?<=トランザクションID:).*(?=\n)


ここから、トランザクションIDを抜き出したい！そういう時は、正規表現を使って一発です。本文をString型で取得し、Matchesアクティビティを使って上記の正規表現でマッチした結果Matches(0)を抽出すればいいだけの話ですが、今回はStudioX向け。つまり初学者向けに正規表現とかわからなくても、Excelの機能を使って抽出をしていきたいと思います。

初学者が陥りやすいケースその1 Excel

初学者が陥りやすいパターンの一つとしては、一つのセルに本文データをすべて抽出してしまうというケースです。

本文を一つのセルに入れがちです。これだと、抽出をするのが難しくなってきます。

[データ テーブルを生成]を使用して、文字列をテーブルにする

ひとつのセルにすべての本文を貼り付けるのではなく、各行ずつに本文を抽出できればいいのです。

ここで必要なアクティビティが「データテーブルを生成」です。概要としては、テキストをデータに変換してくれるアクティビティです。まずオプションをクリックします。

①は必須ではないです。サンプルとなる文字列としてメールの本文を手動で入力してみます。（サンプル入力したほうがわかりやすいので便宜上行っているだけです）

②改行文字から[改行]を選択し、

③プレビューを押下

すると、テストプレビュー欄に行ごとに区切られたデータが生成されるので、OKボタンを押下します。

 

 

ノートブックを開いてみます。無事に各行ごとにExcelに反映されていることを確認できました。

 

このままだと、A5セルには不要な文字があるので、隣の列C5に数式を記入します。
=SUBSTITUTE(A4,”トランザクションID:”,””)

 

数式を埋め込んだセル番地に名前「トランザクションID」を入力します。

 

サンプルワークフローを見てみる

以下がサンプルファイルになります。

このワークフローの注意点

抽出したい値の行数が異なる場合
置換したい文字列が異なる場合
エラーになるので気を付けてください。

180件のフィードバック

  4. Oh my goodness! a tremendous article dude. Thanks However I’m experiencing problem with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting an identical rss problem? Anybody who knows kindly respond. Thnkx

    返信

  5. hey there and thanks in your info – I have definitely picked up something new from proper here. I did then again experience a few technical points the usage of this website, as I skilled to reload the website lots of times previous to I may get it to load properly. I were puzzling over if your web hosting is OK? Now not that I’m complaining, however sluggish loading cases occasions will very frequently impact your placement in google and can harm your quality ranking if ads and ***********|advertising|advertising|advertising and *********** with Adwords. Anyway I’m adding this RSS to my e-mail and can look out for much more of your respective interesting content. Ensure that you replace this again soon..

    返信

  10. I like what you guys are up also. Such intelligent work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it’ll improve the value of my site 🙂

    返信

  11. hello there and thank you in your information – I have certainly picked up something new from right here. I did however expertise some technical issues the usage of this web site, since I skilled to reload the site a lot of times previous to I may just get it to load correctly. I had been wondering if your hosting is OK? Not that I am complaining, but slow loading instances times will often impact your placement in google and can harm your high-quality ranking if advertising and ***********|advertising|advertising|advertising and *********** with Adwords. Well I’m adding this RSS to my email and could glance out for a lot more of your respective fascinating content. Make sure you update this once more very soon..

    返信

  12. Hey there! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my website
    to rank for some targeted keywords but I’m not seeing
    very good success. If you know of any please share.

    Thanks! I saw similar article here: Blankets

    返信

  14. I have to express my thanks to this writer for bailing me out of this problem. Just after researching throughout the internet and seeing tips that were not powerful, I was thinking my life was done. Living without the strategies to the difficulties you’ve solved by means of your good blog post is a serious case, as well as those which might have negatively damaged my career if I had not encountered your site. Your main mastery and kindness in handling the whole thing was tremendous. I am not sure what I would have done if I had not encountered such a solution like this. I can also at this moment look forward to my future. Thank you very much for this specialized and amazing help. I will not think twice to suggest your web page to any individual who needs tips on this situation.

    返信

  15. I’m impressed, I need to say. Really not often do I encounter a blog that’s each educative and entertaining, and let me tell you, you may have hit the nail on the head. Your thought is outstanding; the problem is something that not enough individuals are speaking intelligently about. I’m very joyful that I stumbled across this in my seek for one thing relating to this.

    返信

  16. I do like the manner in which you have presented this particular difficulty plus it does indeed provide me personally a lot of fodder for consideration. However, coming from just what I have seen, I simply hope when the actual reviews stack on that individuals keep on point and in no way embark on a tirade associated with the news du jour. All the same, thank you for this superb piece and although I do not really go along with this in totality, I respect the perspective.

    返信

  18. Hey there! Do you know if they make any plugins to help withSEO? I’m trying to get my blog to rank for some targeted keywords but I’mnot seeing very good success. If you know of any please share.Thank you!

    返信

  19. Thank you for another magnificent article. Where else could anybody get that kind of information in such a perfect way of writing? I have a presentation next week, and I’m on the look for such information.

    返信

  21. Can I use your phone? furacin soluble dressing merhem ne merhemi It also includes a seven-day disabled list for concussions and protocols for allowing players to return to play.

    返信

  30. เว็บตรงไม่ผ่านเอเย่น ระบบมั่นคง ปลอดภัยเรื่องการเงินฝาก-ถอน ระบบออโต้ไม่มีขั้นต่ำ ถอนเท่าไหร่ก็ได้ ไม่จำกัดครั้ง แอดมินตอบไว ตลอด24ชั่วโมง ⌚ระบบอัตโนมัติ ไม่ต้องทำเทริน์ สมัครสมาชิกฟรี คลิ๊งตรงนี้เลย ⬇

    返信

  31. I do not even know how I ended up here, but I thought this post was good. I do not know who you are but definitely you are going to a famous blogger if you are not already Cheers!

    返信

  33. Usually I do not learn article on blogs, but I would like to say that this write-up very forced me to try and do so! Your writing taste has been amazed me. Thank you, very nice post.

    返信

  34. Hello! I just would like to offer you a huge thumbs up for the great info you have got here on this post. I am returning to your blog for more soon.

    返信

  39. Hi there! I just wanted to ask if you ever haveany issues with hackers? My last blog (wordpress) washacked and I ended up losing several weeks of hard work due to no data backup.Do you have any methods to protect against hackers?

    返信

  64. I have to show some thanks to the writer for bailing me out of such a trouble. As a result of browsing through the the web and coming across tips which are not pleasant, I was thinking my entire life was done. Living minus the answers to the issues you’ve sorted out through your short post is a crucial case, and the ones that would have negatively damaged my career if I had not come across your web page. Your main ability and kindness in dealing with everything was helpful. I don’t know what I would’ve done if I had not encountered such a solution like this. I am able to at this time relish my future. Thank you very much for this expert and result oriented help. I will not hesitate to recommend your web blog to any individual who should receive counselling about this problem.

    返信

  76. Awsome post and right to the point. I am not sure if this is actually the best place to ask but do you folks have any thoughts on where to get some professional writers? Thanks in advance

    返信

  96. Generally I don’t read article on blogs, but I would like to say that this write-up very compelled me to try and do so! Your writing style has been amazed me. Thanks, very great post.

    返信

  97. It’s in point of fact a nice and helpful piece of information. I am satisfied that you just sharedthis useful info with us. Please keep us up to date like this.Thanks for sharing.

    返信

  102. Heya! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no backup. Do you have any methods to prevent hackers?

    返信

  103. Fantastic beat ! I would like to apprentice even as you amend your site, how could i subscribe for a weblog site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright transparent idea

    返信

  105. Thank you for another magnificent post. Where else could anyone get that kind of information in such a perfect way of writing? I’ve a presentation next week, and I am on the look for such information.

    返信

  106. A powerful share, I simply given this onto a colleague who was doing a little bit analysis on this. And he in reality purchased me breakfast because I found it for him.. smile. So let me reword that: Thnx for the deal with! But yeah Thnkx for spending the time to debate this, I feel strongly about it and love reading more on this topic. If potential, as you change into expertise, would you mind updating your weblog with extra details? It’s extremely useful for me. Huge thumb up for this weblog post!

    返信

  107. Thanks so much for giving everyone an extremely pleasant possiblity to discover important secrets from this site. It can be very useful and packed with a good time for me and my office friends to search your site no less than three times in a week to see the newest items you have got. And of course, I am usually pleased concerning the incredible tips served by you. Certain two facts on this page are ultimately the best I’ve had.

    返信

  109. hey there and thank you for your information – I have certainly picked up something new from right here. I did however expertise a few technical issues using this site, since I experienced to reload the site a lot of times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I’m complaining, but slow loading instances times will sometimes affect your placement in google and could damage your high-quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my email and can look out for a lot more of your respective fascinating content. Make sure you update this again very soon..

    返信

  113. Thanks , I’ve recently been looking for information about this topic for ages and yours is the best I’ve discovered till now. But, what about the bottom line? Are you sure about the source?

    返信

  115. Wow that was odd. I just wrote an incredibly long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Anyway, just wanted to say great blog!

    返信

  116. This web site is known as a walk-through for all the info you wished about this and didn’t know who to ask. Glimpse right here, and you’ll positively uncover it.

    返信

  118. Fascinating blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog shine. Please let me know where you got your theme. Appreciate it

    返信

  130. whoah this weblog is magnificent i love studying your articles. Keep up the good work! You know, lots of people are looking round for this information, you could aid them greatly.

    返信

コメントを残す

メールアドレスが公開されることはありません。 ※ が付いている欄は必須項目です

目次