Search Results

Thanks, If the file is having three columns with delimiter "|" and i need to the trim only on column 3. Can you please help on this?

column1|column2|column3
1|aa1|704 - sample - test...

How to remove using the sed/awk if the rows are starting with any numbers till "-" character. from the below sample output and expected results.

Sample looks like below :

704 - sample -...

XLS. Thanks

Attached is the sample Excel, How do i convert this Excel in to pipe delimiter flat file (.csv) through the script? looking to automate this.

Thanks for the quick reply, Inputs are in Excel. and i need your help in converting this excel to .csv file.

--- Post updated at 05:30 PM ---

After converting the Excel File to .csv file
...

I have Excel file with the below three columns, i need your expertise in converting this to .csv file delimiter "|"

Excel -
Serial Number Serial Name Serial Brand
111 ...