Hi DEV Folks,
Is there a way to get FLAT File import with column value delimited by | (pipe), instead of CSV file.
We tried CSV file and could not extract data from CSV, since text in columns also has commas.
Also let me know if we can get XML import in following format:
Your help will be appreciated ighly.
Two things you should try:
In Excel, format=html is the best way to import the data.
Also, try format=xml2
Retrieving data ...