Yes, you can proceed—there are no character limitations for Blue Prism Data Items with the Text data type. If you still encounter issues, we can address them using VB.NET or C#.NET code.
Try reading the file as a text file and replacing the '|' character with a blank in a single step. After the replacement, convert the text into CSV format. You can then either proceed with collection-based manipulation for further processing or save ...
Make sure to take a backup(Create a BP Release file) before the password expires, and import it after adding the new license. This approach worked for me—give it a try.
