awk condition for 30th column of a line is not working











up vote
-1
down vote

favorite
1












My Input file looks like below,



1,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,,kapeta,,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,C

2,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,20181006T11:57:13+0100,,vsuser,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,H

1,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,,enrruac,,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,C

4,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,20181007T22:25:13+0100,,vsuser,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,H


i want to print only the line that are starting with '1' and ends with 'C', so i am trying with below command,



awk -F, '$1=='1' && $31=='C'{print $0}' input_file.txt


but i am not getting any output.






awk syntax quotes nawk







share|improve this question




















  • 2




    With a regex: awk '/^1.*C$/' file or awk '/^1,.*,C$/' file
    – Cyrus
    2 days ago

















up vote
-1
down vote

favorite
1












My Input file looks like below,



1,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,,kapeta,,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,C

2,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,20181006T11:57:13+0100,,vsuser,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,H

1,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,,enrruac,,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,C

4,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,20181007T22:25:13+0100,,vsuser,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,H


i want to print only the line that are starting with '1' and ends with 'C', so i am trying with below command,



awk -F, '$1=='1' && $31=='C'{print $0}' input_file.txt


but i am not getting any output.






awk syntax quotes nawk







share|improve this question




















  • 2




    With a regex: awk '/^1.*C$/' file or awk '/^1,.*,C$/' file
    – Cyrus
    2 days ago















up vote
-1
down vote

favorite
1









up vote
-1
down vote

favorite
1






1





My Input file looks like below,



1,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,,kapeta,,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,C

2,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,20181006T11:57:13+0100,,vsuser,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,H

1,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,,enrruac,,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,C

4,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,20181007T22:25:13+0100,,vsuser,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,H


i want to print only the line that are starting with '1' and ends with 'C', so i am trying with below command,



awk -F, '$1=='1' && $31=='C'{print $0}' input_file.txt


but i am not getting any output.






awk syntax quotes nawk







share|improve this question















My Input file looks like below,



1,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,,kapeta,,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,C

2,,B4,3000,Rushab,UNI,20130919T22:45:05+0100,20190930T23:59:59+0100,20181006T11:57:13+0100,,vsuser,6741948090816,2285917436,971078887,1283538808965528,20181102_20001,,,,,,,,,,,,,,,H

1,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,,enrruac,,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,C

4,,F1,100000,RAWBANK,UNI,20180416T15:25:00+0100,20190416T23:59:59+0100,20181007T22:25:13+0100,,vsuser,7522609506635,3101315044,998445487,1290161608965816,20181102_20001,,,,,,,,,,,,,,,H


i want to print only the line that are starting with '1' and ends with 'C', so i am trying with below command,



awk -F, '$1=='1' && $31=='C'{print $0}' input_file.txt


but i am not getting any output.






awk syntax quotes nawk




awk syntax quotes nawk






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 2 days ago









Cyrus

44.1k43375




44.1k43375










asked 2 days ago









ramki_ramakrishnan

41117




41117








  • 2




    With a regex: awk '/^1.*C$/' file or awk '/^1,.*,C$/' file
    – Cyrus
    2 days ago
















  • 2




    With a regex: awk '/^1.*C$/' file or awk '/^1,.*,C$/' file
    – Cyrus
    2 days ago










2




2




With a regex: awk '/^1.*C$/' file or awk '/^1,.*,C$/' file
– Cyrus
2 days ago






With a regex: awk '/^1.*C$/' file or awk '/^1,.*,C$/' file
– Cyrus
2 days ago














2 Answers
2






active

oldest

votes

















up vote
3
down vote













Use double quotes:



awk -F, '$1=="1" && $31=="C"{print $0}' file


or



awk -F, '$1=="1" && $31=="C"' file





share|improve this answer





















  • Note that 1 doesn't require quotes.
    – karakfa
    2 days ago


















up vote
1
down vote













As other users suggested, this can be done using a simple regex. So you can use sed as well as awk



sed '/^1,.*,C$/!d' file





share|improve this answer



















  • 1




    If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
    – karakfa
    2 days ago










  • @karakfa updated, thanks!
    – oguzismail
    2 days ago











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53184039%2fawk-condition-for-30th-column-of-a-line-is-not-working%23new-answer', 'question_page');
}
);

Post as a guest


















2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
3
down vote













Use double quotes:



awk -F, '$1=="1" && $31=="C"{print $0}' file


or



awk -F, '$1=="1" && $31=="C"' file





share|improve this answer





















  • Note that 1 doesn't require quotes.
    – karakfa
    2 days ago















up vote
3
down vote













Use double quotes:



awk -F, '$1=="1" && $31=="C"{print $0}' file


or



awk -F, '$1=="1" && $31=="C"' file





share|improve this answer





















  • Note that 1 doesn't require quotes.
    – karakfa
    2 days ago













up vote
3
down vote










up vote
3
down vote









Use double quotes:



awk -F, '$1=="1" && $31=="C"{print $0}' file


or



awk -F, '$1=="1" && $31=="C"' file





share|improve this answer












Use double quotes:



awk -F, '$1=="1" && $31=="C"{print $0}' file


or



awk -F, '$1=="1" && $31=="C"' file






share|improve this answer












share|improve this answer



share|improve this answer










answered 2 days ago









Cyrus

44.1k43375




44.1k43375












  • Note that 1 doesn't require quotes.
    – karakfa
    2 days ago


















  • Note that 1 doesn't require quotes.
    – karakfa
    2 days ago
















Note that 1 doesn't require quotes.
– karakfa
2 days ago




Note that 1 doesn't require quotes.
– karakfa
2 days ago












up vote
1
down vote













As other users suggested, this can be done using a simple regex. So you can use sed as well as awk



sed '/^1,.*,C$/!d' file





share|improve this answer



















  • 1




    If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
    – karakfa
    2 days ago










  • @karakfa updated, thanks!
    – oguzismail
    2 days ago















up vote
1
down vote













As other users suggested, this can be done using a simple regex. So you can use sed as well as awk



sed '/^1,.*,C$/!d' file





share|improve this answer



















  • 1




    If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
    – karakfa
    2 days ago










  • @karakfa updated, thanks!
    – oguzismail
    2 days ago













up vote
1
down vote










up vote
1
down vote









As other users suggested, this can be done using a simple regex. So you can use sed as well as awk



sed '/^1,.*,C$/!d' file





share|improve this answer














As other users suggested, this can be done using a simple regex. So you can use sed as well as awk



sed '/^1,.*,C$/!d' file






share|improve this answer














share|improve this answer



share|improve this answer








edited 2 days ago

























answered 2 days ago









oguzismail

1,739516




1,739516








  • 1




    If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
    – karakfa
    2 days ago










  • @karakfa updated, thanks!
    – oguzismail
    2 days ago














  • 1




    If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
    – karakfa
    2 days ago










  • @karakfa updated, thanks!
    – oguzismail
    2 days ago








1




1




If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
– karakfa
2 days ago




If you don't add the delimiters there will be false matches. For example. 11,....,NotC will match as well. /^1,.*,C$/!d should fix this.
– karakfa
2 days ago












@karakfa updated, thanks!
– oguzismail
2 days ago




@karakfa updated, thanks!
– oguzismail
2 days ago


















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53184039%2fawk-condition-for-30th-column-of-a-line-is-not-working%23new-answer', 'question_page');
}
);

Post as a guest






































































-

Popular posts from this blog

横浜市

Image
よこはまし 横浜市 横浜みなとみらい21 横浜中華街 日本丸 横浜駅西口前 横浜マリンタワー 横浜市旗 横浜市章 1909年6月5日制定 [注釈 1] 国 日本 地方 関東地方 都道府県 神奈川県 団体コード 14100-3 法人番号 3000020141003 面積 437.56 km 2 総人口 3,740,172 人 [編集] （推計人口、2018年10月1日） 人口密度 8,548 人/km 2 隣接自治体 川崎市 藤沢市 大和市 横須賀市 鎌倉市 逗子市 東京都 町田市 市の木 イチョウ、ケヤキ、サザンカ、 サンゴジュ、シイ、ツバキ 市の花 バラ 市の歌 横浜市歌 横浜市役所 市長 [編集] 林文子 所在地 〒 231-0017 神奈川県横浜市中区港町1丁目1番地 北緯35度26分38.3秒東経139度38分17.7秒 座標: 北緯35度26分38.3秒 東経139度38分17.7秒 外部リンク 横浜市 ■ ― 政令指定都市 / ■ ― 市 / ■ ― 町 / ■ ― 村 地理院地図 Google Bing GeoHack MapFan Mapion Yahoo! NAVITIME ゼンリン   表示   ウィキプロジェクト ポータル 横浜市 横浜市 （よこはまし）は、関東地方南部、神奈川県の東部に位置する都市で、同県の県庁所在地。政令指定都市の一つであり、18区の行政区を持つ。現在の総人口は日本の市町村では最も多く、四国地方に匹敵するおおよそ373万人であり1府37県の人口を上回る。人口集中地区人口は東京23区（東京特別区）、大阪市に次ぐ。神奈川県内の市町村では、面積が最も広い。市域の過半は旧武蔵国で、南西部は旧相模国（戸塚区、泉区、栄区、瀬谷区 [1] の全域と港南区の一部）。 幕末以降から外国資本が積極的に当地に進出（詳しくは後述）。そのため近代日本において有数の外資獲得力を誇...
Read more

Rostock

Image
Der Titel dieses Artikels ist mehrdeutig. Weitere Bedeutungen sind unter Rostock (Begriffsklärung) aufgeführt. Wappen Deutschlandkarte 54.083333333333 12.133333333333 14 Koordinaten: 54° 5′  N , 12° 8′  O Basisdaten Bundesland: Mecklenburg-Vorpommern Höhe: 14 m ü. NHN Fläche: 181,26 km 2 Einwohner: 208.409 (31. Dez. 2017) [1] Bevölkerungsdichte: 1150 Einwohner je km 2 Postleitzahlen: 18055, 18057, 18059, 18069, 18106, 18107, 18109, 18119, 18146, 18147, 18181, 18182 Vorlage:Infobox Gemeinde in Deutschland/Wartung/PLZ enthält Text Vorwahlen: 0381, 038202, 038206 Kfz-Kennzeichen: HRO Gemeindeschlüssel: 13 0 03 000 NUTS: DE803 Stadtgliederung: 21 Stadtbereiche, 31 Ortsteile Adresse der Stadtverwaltung: Neuer Markt 1 18055 Rostock Webpräsenz: www.rathaus.rostock.de Oberbürgermeister: Roland Methling (parteilos) Lage von Rostock in Mecklenburg-Vorpommern ...
Read more

Europa

Image
Ten artykuł dotyczy części świata (kontynentu). Zobacz też: inne znaczenia tego słowa. Europa Mozaika zdjęć satelitarnych Europy (z wyciętymi rzekami) Państwo Państwa Europy Powierzchnia 10,2 mln km² Miejscowości największe aglomeracje [1] : Moskwa, Paryż, Londyn, Essen-Düsseldorf, Madryt, Mediolan, Berlin, Warszawa, Rzym, St. Petersburg Wysokość max : 4811 m n.p.m., Mont Blanc; min : 28 m p.p.m., Nizina Nadkaspijska Rodzaj obiektu subkontynent Położenie na mapie świata Europa 50°N   15°E / 50,000000   15,000000 Mapa hipsometryczna Europy Multimedia w Wikimedia Commons Informacje w Wikipodróżach Zobacz w indeksie Słownika geograficznego Królestwa Polskiego hasło Europa Europa Mapa polityczna Europy Europa – część świata (nazywana zwykle, jednak nieściśle, kontynentem) leżąca na półkuli północnej, na pograniczu półkuli wschodniej i zachodniej, której część kontynentalna stanowi wra...
Read more