XLS/CSV Archives - Page 3 of 4 - File transfer tool from Limagito

04 Apr
Q&A 42: Remove quotation marks around the data in a csv file
Q: Remove quotation marks around the data in a csv file. An Excel file is saved that has quotation marks around the data in the file. Which can be removed by opening Excel and re-saving as the CSV, but this is a manual step at this time. Would we be able to setup a Limagito rule to be able to do something similar for us?
A: Yes this is possible using our XLS as Destination option. XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention so we know we need to handle them differently.
Some screenshots to get you started:
1. Since we only want csv files, be sure the set the ‘Filename Include’ filter to *.csv in the ‘File Filter Setup’.
2. We added XLS as Destination, XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention.
3. XLS.CSV as Destination setup. The Output File Format will be ‘Text, Delimiter separated values – with CRLF as End Of Line’.
Also ‘Text, Delimiter separated values – with LF as End Of Line’ which was added in version v2021.4.4.0
This way you also can convert:
CSV with CRLF as Source to CSV with LF as end Of Line Destination
CSV with LF as Source to CSV with CRLF as end Of Line Destination
To remove the quotation marks you need to enable ‘Import full csv file as text’ option (Common Tab).
#FileTransfer
If you need any help with this ‘Remove quotation marks’ request, please let us know.
Happy Easter,
Limagito Team
By Limagito-Team Q&A XLS/CSV crlf, csv, linefeed, marks, quotation
12 Jul
Q&A 20: I’d love the option to go the other way, csv to xls
Q: It seems XLS as destination is meant to convert Xls as source file. I’d love the option to go the other way, csv to xls. Oh well, feature request.
A: You are correct the original idea was to convert XLS files but on your request we added this feature request in version v2020.7.12.0
We added some screenhosts to give you an idea about the setup. The Source is a Windows folder:
We added a file filter to only include *.txt and *.cvs files:
As Destination we added our ‘Add XLS’ option:
The Csv file that we are going to convert has a comma as delimiter. Our goal is to convert the Csv source file to a Xls file. We enabled ‘Change Extension’ and added .xls as ‘Extension’. File Format was set to ‘Xls, Excel 97-2000-XP-2003’.
Result:
If you need any help , please let us know.
Regards,
Limagito Team
By Limagito-Team Q&A XLS/CSV csv, xls
05 May
XLS as Destination, Part 2
Dear users,
v2019.5.5.0
If you missed the first parts: https://limagito.com/xls-as-destination/
We’ve add the following new options to the XLS(X)/CSV as Destination option.
Sheets, delete options:
With this option you can select which sheets you want to delete using index or name of the sheet(s). Remember, the sheet index starts at 1.
With the setup in the screenshot below we are going to delete the sheet with index 5 AND the sheet with name ‘SheetNameToDelete’.
Colums, delete options:
With this option you can select which columns you want to delete on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, column and sheet indexes start at 1.
With the setup in the screenshot below we are going to delete column with index 2 on sheet with index 1.
Rows, delete options:
With this option you can select which rowss you want to delete on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, row and sheet indexes start at 1.
With the setup in the screenshot below we are going to delete row with index 1 on sheet with index 1.
Cell Values, rename options:
With this option you can rename cell values in rows and colmuns on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, row , column and sheet indexes start at 1 (value = 0 = all rows/columns).
With the setup in the screenshot below we are going to rename all columns of the first row on sheet with index 1. The text part ‘Before’ will be replaced by ‘After’ if the cell type is ‘Text’ (String).
Please let us know if you have any question or need help with the setup
Regards,
Lilmagito Team,
Pascal
By Limagito-Team XLS/CSV csv, xls