Save Tab-delimited as Semi-colon delimited
Closed
Netscur
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
-
Jan 11, 2012 at 11:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 7, 2012 at 07:14 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 7, 2012 at 07:14 AM
Related:
- Save Tab-delimited as Semi-colon delimited
- Save as pdf office 2007 - Download - Other
- Save as icon - Guide
- Java update tab missing - Guide
- How to save audio from messenger - Guide
- Save from net - Download - Video downloads
2 responses
Netscur
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
Apr 6, 2012 at 01:09 PM
Apr 6, 2012 at 01:09 PM
After weeks of on-again off-again searches I found what appears to be the only solution (solutions depending on the original file format).
1.ETL requires a .csv format
One process that worked for my needs was to change the file extension before opening. For example, if it was a .CSV I changed it to a .TXT. Then opened Excel and used the File Manager to open the TXT document. After the manipulation, I then saved the document as a .CSV and the format was accepted by my ETL
2. ETL requires a .txt format
The other process which worked.... if the file was already a .TXT format, I opened it through Excel. After performing my manipulation, I went into the Tool>Options and in the International tab I un-checked "Use system separators" and put a comma (',') in the "Decimal separator" field.
At this point, it is time to save the document as a .CSV. Once the saving was complete, I renamed the file extension to .TXT and the ELT process was able to load it.
When done, I made sure to set my Internation Settings for "separators" back to default, so opening other documents would function as expected.
1.ETL requires a .csv format
One process that worked for my needs was to change the file extension before opening. For example, if it was a .CSV I changed it to a .TXT. Then opened Excel and used the File Manager to open the TXT document. After the manipulation, I then saved the document as a .CSV and the format was accepted by my ETL
2. ETL requires a .txt format
The other process which worked.... if the file was already a .TXT format, I opened it through Excel. After performing my manipulation, I went into the Tool>Options and in the International tab I un-checked "Use system separators" and put a comma (',') in the "Decimal separator" field.
At this point, it is time to save the document as a .CSV. Once the saving was complete, I renamed the file extension to .TXT and the ELT process was able to load it.
When done, I made sure to set my Internation Settings for "separators" back to default, so opening other documents would function as expected.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 7, 2012 at 07:14 AM
Apr 7, 2012 at 07:14 AM
I thought when you save a file, there is one option to save as a comma delimited file. I am not sure about semi colon delimited file.
