This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm in need of some assistance. I have a text input that is 19,012 characters long that does not have any line breaks. Screenshot provided below and example attached:
The words "FROM", "TO", & "FOR" need to be replaced with a column break and the word "HOURS" needs to be replaced with a line break in order to properly format this information.
-How should i input this data? i have tried using the input tool but it always asks to parse the data first. I have tried ingesting as a csv with a \0 delimiter as suggested in some threads but i get a field truncation warning when i do this and it cuts a majority of my data out.
-Im assuming the most efficient way of parsing the data is going to be REGEX. I am not very well versed in REGEX and am curious how one would go about properly parsing this data via REGEX.
i will take a look at this for you, but I'm sure that I'll have company. I'll likely read it as CSV with \0 as a delimiter, but I'll also change the default 254 length to 20,000. Then I will avoid RegEx and use replace() commands to get a PIPE in as a delimiter. Then figure out how to handle line breaks.
If when I look at the data I find a simple fixed width solution, I'll switch to that path.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.