Hello everybody. I am having problem inporting a custom formet. I have checked past posts but nothing has helped. The custom format I am trying to import is PNEZD comma dilimted. i have the csv fils on my desktop and this is what shows up.
Can somebody a heck of a lot smarter then me HELP!!!!!!!
Solved! Go to Solution.
Solved by ToddRogers-WPM. Go to Solution.
My guess is there is a header in the CSV file. Open it in Excel and make sure there are no headers in the columns. If there is, delete them.
MM,
Crack open that text file with a text editor and check to see if it truly is comma delimited. Also, it might have a header that's messing things up, or be missing carriage returns.
Dave
Dave Stoll
Las Vegas, Nevada
I never use a .csv file. Always use Notepad's .txt file. It is easy to open and see if you have something "dangling" there you do not need.
Bill
It should be noted and I use this all the time to assist translation & working when in large databases where you have more depth values in differing columns (eg Boreholes)
If you add a symbol such as the hash key "#" prior to the header name (eg #Elevation) you can then ignore them on import by specifying the ignore # in the comment tag and also in each header using the invalid indicator.
You can then keep your headers and import as normal.
I do however find csv files cause lots of agro. I use excel to add data or calcalate values then export as csv file, Open the CSV in notepad and save as a ANSI file.
It still does appear to be hit and miss. I have in the past opened a csv which fails to import and copy/paste the entire file contents into annother one which did work via notepad then saved and imported fine.
Mike
Can't find what you're looking for? Ask the community or share your knowledge.