RegEx Tool

[CsmithData31]

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. 

[flying008]

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.

[OllieClarke]

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

[CsmithData31]

haha tell me about it!

[binuacs]

@CsmithData31 Another way of doing this is by reading the file Flat ASCII and use split by fixed length option