I read the email and generate a data table with the delimiter as colon. One of the mails had 2 colons in one of the rows and it didn’t pick details of the entire text, it cut the column based on the 2nd colon and prints only “note” from the below example.
If I try to use a split string - the other rows with just one colon gets affected and it throws “Cannot find column 1” error. How to resolve this?
@prasath17 - “Rep Note: note: 2021 Tokyo Olympic games airing July 23 to Aug 8 -
contact your rep for avails and booking procedures”
This is the input and “note: 2021 Tokyo Olympic games airing July 23 to Aug 8 -
contact your rep for avails and booking procedures” is the output I want
str_Text = “Rep Note: note: 2021 Tokyo Olympic games airing July 23 to Aug 8 -
contact your rep for avails and booking procedures”
str_Output = str_Text.Remove(0,instr(str_Text,":"))
str_Output will get value with text after first “:”. You can also remove unnecessary white spaces with:
This threw me an error. It is considering the entire text as column 2 and throws an error that column 1 is not found in the part where I am adding it to the dictionary
It reads an entire email and converts it into data table and picks 2nd column values alone. I can’t pick out one row of the mail alone to do the above operation.
Now I didn’t understand your requirement…
Tell me steps from you reading the email…
which activity you are using to read email…and then what is output of read email you are getting …
And what do you mean by convert entire email into data table and pick only second column alone?
Ok so @Pravin_Patil1 gave you the right solution. In that case the simplest one is just to check the data in dict before pasting it to form and then split operation or regex will do the trick
I unchecked csv parsing even then it takes the entire value as a column and throws an error. It looks fine in your screenshot, not sure why it isn’t working for me.