Hello!
I have a text file that I am having trouble parsing out a file using the RegEx tool. I am able to parse out date and reference using the following regex but having trouble with Ful name and remaining columns.
(\d{2}/\d{2}/\d{4})\s(\<\w+\>)\s+
Sample text file attached.
Solved! Go to Solution.
Hi, @BS_THE_ANALYST
I just only follow sample table picture of @CsmithData31 , so , If @CsmithData31 can give a cleaning output table for want, then i will be adjust the regex expression to catch it.
In terms of writing a RegEx to parse the data, I think it's much easier if you reverse the string before parsing it, as the easier structured bits are at the end of the string
([-\.\d]+)\s*(\d+)\s*(\d+)\s*(\d+)\s*(\d+)\s*(\u+)\s*(\u+)\s*(.*?)\s{2,}(\u.+?\u)\s*(\w+)\s*(\d{4}/\d{2}/\d{2})
but there are already solutions in this thread - just throwing in my oar
haha tell me about it!
@CsmithData31 Another way of doing this is by reading the file Flat ASCII and use split by fixed length option