| Newsgroups |
gmane.editors.sed.user |
| Message-ID |
<[email protected]> |
sed -rn '/([^;]*;){6}[^;]*[A-Za-z][^;]*;[^;]*;/!p' yourfile
On 22/03/16 17:19, MOKRANI Rachid [email protected] [sed-users] wrote:
> Hi,
>
> Do you have a simple proposal with sed / awk.
>
> if I find alphabetic characters (a-z A-Z) in column 7 I want to delete the line.
>
>
> "111222333";"Company A";"NAME A ";"FIRSTNAME 1";"JOB 1";"Town 1";"52.45.0";"COMMENT 1";
>
> "111222334";"Company A";"NAME A ";"FIRSTNAME 4";"JOB 1";"Town 1";"PH56.2458";"";
>
> "118822333";"Company B";"NAME T ";"FIRSTNAME 1";"JOB 2";"Town 2";"aGrfDPHONE 65"; "COMMENT 1235";
>
> "111275333";"Company C";"NAME M ";"FIRSTNAME 2";"JOB 7";"Town 1";"14582";"";
>
> "55222334";"Company Y";"NAME G ";"FIRSTNAME 4";"JOB 52";"Town 1";"-45852";"";
>
> "1258425";"Company Y";"NAME F ";"FIRSTNAME 8";"JOB 82";"Town 3";"+45 85 20";"";
>
>
>
>
>
> Need to obtain the result below.
>
>
> "111222333";"Company A";"NAME A ";"FIRSTNAME 1";"JOB 1";"Town 1";"52.45.0";"COMMENT 1";
>
> "111275333";"Company C";"NAME M ";"FIRSTNAME 2";"JOB 7";"Town 1";"14582";"";
>
> "55222334";"Company Y";"NAME G ";"FIRSTNAME 4";"JOB 52";"Town 1";"-45852";"";
>
> "1258425";"Company Y";"NAME F ";"FIRSTNAME 8";"JOB 82";"Town 3";"+45 85 20";"";
>
>
> Thanks,
> Best regards.
> __________________________
> Avant d'imprimer, pensez à l'environnement ! Please consider the environment before printing !
> Ce message et toutes ses pièces jointes sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. IFP Energies nouvelles décline toute responsabilité au titre de ce message. This message and any attachments are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. IFP Energies nouvelles should not be liable for this message.
> __________________________
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
> Posted by: MOKRANI Rachid <[email protected]>
> ------------------------------------
>