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?
ABC:
Client: 1
Rep Note Type: Proposal
Rep Note: note: 2021 qwerrtty