Trim Leading and trailing Spaces in Awk

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

I have a file which contains 1 line like below

 VINOTH                                                                                    |KARTHICK                                                                                       |RAVI

I'm using the below command to remove the leading and trailing spaces , but it's not not working.

awk '{ gsub(/^[ t]+|[ t]+$/, ""); print }' Input_File

Please help.

Required Output.

VINOTH|KARTHICK|RAVI

asked Jan 3 at 12:53

Vinoth Karthick

164114

1

Try sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

– Wiktor Stribiżew
Jan 3 at 13:03

It's working. Could you please explain the Statement?

– Vinoth Karthick
Jan 3 at 13:06

Maybe a stupid question, but you have one word in your input file, and it appears as 3 words with a pipe as the delimiter. ... how come?

– kvantour
Jan 3 at 15:27

Please use the horizontal scroll bar to see the full Line

– Vinoth Karthick
Jan 3 at 17:35

add a comment |

I have a file which contains 1 line like below

 VINOTH                                                                                    |KARTHICK                                                                                       |RAVI

I'm using the below command to remove the leading and trailing spaces , but it's not not working.

awk '{ gsub(/^[ t]+|[ t]+$/, ""); print }' Input_File

Please help.

Required Output.

VINOTH|KARTHICK|RAVI

asked Jan 3 at 12:53

Vinoth Karthick

164114

1

Try sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

– Wiktor Stribiżew
Jan 3 at 13:03

It's working. Could you please explain the Statement?

– Vinoth Karthick
Jan 3 at 13:06

Maybe a stupid question, but you have one word in your input file, and it appears as 3 words with a pipe as the delimiter. ... how come?

– kvantour
Jan 3 at 15:27

Please use the horizontal scroll bar to see the full Line

– Vinoth Karthick
Jan 3 at 17:35

add a comment |

I have a file which contains 1 line like below

 VINOTH                                                                                    |KARTHICK                                                                                       |RAVI

I'm using the below command to remove the leading and trailing spaces , but it's not not working.

awk '{ gsub(/^[ t]+|[ t]+$/, ""); print }' Input_File

Please help.

Required Output.

VINOTH|KARTHICK|RAVI

asked Jan 3 at 12:53

Vinoth Karthick

164114

I have a file which contains 1 line like below

 VINOTH                                                                                    |KARTHICK                                                                                       |RAVI

I'm using the below command to remove the leading and trailing spaces , but it's not not working.

awk '{ gsub(/^[ t]+|[ t]+$/, ""); print }' Input_File

Please help.

Required Output.

VINOTH|KARTHICK|RAVI

unix awk ksh

asked Jan 3 at 12:53

Vinoth Karthick

164114

asked Jan 3 at 12:53

Vinoth Karthick

164114

asked Jan 3 at 12:53

Vinoth Karthick

164114

asked Jan 3 at 12:53

Vinoth Karthick

164114

asked Jan 3 at 12:53

Vinoth Karthick

164114

1

Try sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

– Wiktor Stribiżew
Jan 3 at 13:03

It's working. Could you please explain the Statement?

– Vinoth Karthick
Jan 3 at 13:06

Maybe a stupid question, but you have one word in your input file, and it appears as 3 words with a pipe as the delimiter. ... how come?

– kvantour
Jan 3 at 15:27

Please use the horizontal scroll bar to see the full Line

– Vinoth Karthick
Jan 3 at 17:35

add a comment |

1

Try sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

– Wiktor Stribiżew
Jan 3 at 13:03

It's working. Could you please explain the Statement?

– Vinoth Karthick
Jan 3 at 13:06

Maybe a stupid question, but you have one word in your input file, and it appears as 3 words with a pipe as the delimiter. ... how come?

– kvantour
Jan 3 at 15:27

Please use the horizontal scroll bar to see the full Line

– Vinoth Karthick
Jan 3 at 17:35

Try sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

– Wiktor Stribiżew
Jan 3 at 13:03

It's working. Could you please explain the Statement?

– Vinoth Karthick
Jan 3 at 13:06

Maybe a stupid question, but you have one word in your input file, and it appears as 3 words with a pipe as the delimiter. ... how come?

– kvantour
Jan 3 at 15:27

Please use the horizontal scroll bar to see the full Line

– Vinoth Karthick
Jan 3 at 17:35

add a comment |

2 Answers
2

active

oldest

votes

You may use

sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

There are two regexps here:

s/[ t]*|[ t]*/|/g replaces all | enclosed with optional whitespaces with a single | (the | in the regex matches a literal | char as per BRE POSIX standard)

s/^[ t]*|[ t]*$//g removes all whitespaces at the start and end of lines. Note that | here is an OR operator (escaped because the BRE POSIX syntax is used).

See the online demo.

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

add a comment |

Could you please try following(since your sample input and expected output are not clear so didn't test it).

awk '{gsub(/^[[:space:]]+|[[:space:]]+$/,"")} 1'  Input_file

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

add a comment |

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',
autoActivateHeartbeat: false,
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

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54022716%2ftrim-leading-and-trailing-spaces-in-awk%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

You may use

sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

There are two regexps here:

s/[ t]*|[ t]*/|/g replaces all | enclosed with optional whitespaces with a single | (the | in the regex matches a literal | char as per BRE POSIX standard)

s/^[ t]*|[ t]*$//g removes all whitespaces at the start and end of lines. Note that | here is an OR operator (escaped because the BRE POSIX syntax is used).

See the online demo.

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

add a comment |

You may use

sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

There are two regexps here:

s/[ t]*|[ t]*/|/g replaces all | enclosed with optional whitespaces with a single | (the | in the regex matches a literal | char as per BRE POSIX standard)

s/^[ t]*|[ t]*$//g removes all whitespaces at the start and end of lines. Note that | here is an OR operator (escaped because the BRE POSIX syntax is used).

See the online demo.

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

add a comment |

You may use

sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

There are two regexps here:

s/[ t]*|[ t]*/|/g replaces all | enclosed with optional whitespaces with a single | (the | in the regex matches a literal | char as per BRE POSIX standard)

s/^[ t]*|[ t]*$//g removes all whitespaces at the start and end of lines. Note that | here is an OR operator (escaped because the BRE POSIX syntax is used).

See the online demo.

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

You may use

sed 's/[ t]*|[ t]*/|/g;s/^[ t]*|[ t]*$//g' Input_File

There are two regexps here:

s/[ t]*|[ t]*/|/g replaces all | enclosed with optional whitespaces with a single | (the | in the regex matches a literal | char as per BRE POSIX standard)

s/^[ t]*|[ t]*$//g removes all whitespaces at the start and end of lines. Note that | here is an OR operator (escaped because the BRE POSIX syntax is used).

See the online demo.

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

answered Jan 3 at 13:08

Wiktor Stribiżew

330k16149229

add a comment |

Could you please try following(since your sample input and expected output are not clear so didn't test it).

awk '{gsub(/^[[:space:]]+|[[:space:]]+$/,"")} 1'  Input_file

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

add a comment |

Could you please try following(since your sample input and expected output are not clear so didn't test it).

awk '{gsub(/^[[:space:]]+|[[:space:]]+$/,"")} 1'  Input_file

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

add a comment |

Could you please try following(since your sample input and expected output are not clear so didn't test it).

awk '{gsub(/^[[:space:]]+|[[:space:]]+$/,"")} 1'  Input_file

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

Could you please try following(since your sample input and expected output are not clear so didn't test it).

awk '{gsub(/^[[:space:]]+|[[:space:]]+$/,"")} 1'  Input_file

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

answered Jan 3 at 13:13

RavinderSingh13

30.8k41639

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu