format

We have scenario where users enter the date in the email body (free text). Ex: Start Date : 08\24\2021 Start Date : August 24, 2021 Start date : 24\08\2021 Start date : July 24, 2021 @ 3:12 PM I am able to get the entire text followed by Start Date: XXXXXXXXX, Using RegEx Now I...

Hi, I'm currently converting an Excel file to CSV. Step 1: Get data into collection Step 2: Convert collection to CSV Step 3: write it into a file. It works, but there is a problem with Data format error. For example: Excel value - 9781621577720 CSV value - 9.78162E+12 I'd like to know if...

I've been given a CSV file that is organised by this format. It reads something like: ID,1 Name,Ryan DOB,11/11/11 Postcode,xxx xxx I'm able to separate the values into an Excel spreadsheet but struggling to figure out how to efficiently move the cells into my desired format. E.G...

Hi , I need help in sending outlook Email in Rich Text Format , which Outlook Vbo to be called back end , not front end automation. I need to send attachments in body .So looking out for help Thanks Leela

Hey, I need to change the format of my file: xlsx for csv at AutoMate. I tried use the shortcut, but it didn`t work and other thing that I tried was open and save as, but when I change the format it save as xlsx the same way. Someone could help me? Tks :)