I need to get these text into separate separate columns in a excel.The 3rd segment is not having a fixed length, it can vary. This is actually an ouput of a read PDF activity. I READ PDF, then SPLIT by new line to get like this. After this please can anyone help?
If regex can be used, please advice
Thanks in advance