UltraEdit, UltraCompare, UEStudio forums

Thanks. It would be nice if they would enclose values with quotes, but in this case they don't. I have the lines all recorded so I can fix before import. At least with this I can check before and fix the values that contains the pipe by removing and then adding in after import is complete. That's ab...

The first one matches whole lines containing 15 or more delimiters. The second one finds lines containing 14 or less delimiters. Just try them. ;) Okay, thanks. I just did and it looks like it works!

The first one is to find an exact match and the second is to find one less than the number? Is there a way to find the lines that don't match the number specified? Also my end of line is a paragraph symbol if that makes any difference. ^(?:[^\|\t\r\n]*+\|){3}.*\r\n Above would find lines with more t...

This is handy, but how do I change this for the pipe character "|" ? I did the below and doesn't seem to work ^(?:[^\t\r\n]* "|" ){15}.*\r\n Basically, I have a CSV file that is pipe or vertical bar separated. If it doesn't contain the exact number of columns then my import into SQL will fail. Let m...