Search Results

Thank you cabrao and Franklin for your responses.

I tried the following code but didn't work. Please suggest.
#!/bin/bash
awk -F"|" '{while(NF < 6){s=$0;getline;gsub(/^[ \t]+/,x); $0=s...

Hi All,

I've a csv file in which the record is getting break into 1 line or more than one line. I want to combine those splits into one line and remove the unwanted character existing in...

Thank you so much Guruprasad. It works. Appreciate the quick response.

Thank you once again.

Hi All,

I want to remove the rows from File1.csv by comparing the columns/fields in the File2.csv. I only need the records whose first column is same and the second column is different for the...

Hi codemaniac,

I tried the given code but it is giving the following error.
Error: grep: can't open |VIJAY

Actually I'm new to this shell/awk scripting. Is there any help using...

Hi All,

I want to remove the rows from File1.csv by comparing a column/field in the File2.csv. If both columns matches then I want that row to be deleted from File1 using shell script(awk)....

Thank you so much for the help.

Regards,
Rajak

Hi Scott,

This code works great.! Thank you so much for your time and help. Can you please tell me what exactly this code does? Just want to know.

Thanks to everyone who spend their time...

Sorry anchal! Yes, the file is ftping form windows only. Is this causing the issue? Please advise.

Thanks in Advance.

---------- Post updated at 07:19 AM ---------- Previous update was at...

Hi CarloM,

My CSV file:
HRLOAD|Service|AddChange|EN
PERSONID|STATUS|LASTNAME|FIRSTNAME|ITDCLIENTUSERID|ADDRESSLINE1
10000001|ACTIVE|Testazar1|Testore1|20041|...

Hi balajesuri,

thanks for your solution. This may work for my first query but later I've corrected my issue. Actually I'm trying to remove some of the fields from csv which creates the '|'...

My OS is AIX.
I'm not ftping the file from windows. It is with in the same server i.e. AIX server. Any help?

thanks in advance.

Thank you anchal.

Now I figured out that it is not the 'sed' script that is causing the issue. Actually what happens is that I want to remove some fields from my existing csv file using 'awk'....

Hi,

I've a csv file seperated by '|' from which I'm trying to remove the excess '|' characters more than the existing fields. My CSV looks like as below.
HRLOAD|Service|AddChange|EN...