Hi Community 
I wanted to share a quick and efficient method I used to convert uneven, space-separated text data (like this 
) into a clean DataTable in UiPath — without using Regex!
uipath #StringManipulation datatable #TextParsing #NoRegex #AutomationTips
2025-05-16
Studio
Are you sure that isn’t tab-delimited csv? That’s usually how tab-delimited looks in Notepad or other text editors - unevenly spaced.
Hey @postwick ,
In this video, I showcased an example of converting text with uneven whitespaces into an Excel file. I’ve come across similar challenges in a few of my projects where the data wasn’t tab-delimited.
Although converting text to CSV is typically simple, I’ve faced situations where doing so directly led to issues like empty cells or misaligned columns due to inconsistent spacing.
This video highlights those scenarios and demonstrates practical ways to handle and clean such data effectively
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.