Search Results

True I'm sorry.:o

Adding [[:space::]] worked just fine.

Many thanks.

Hi @MadeInGermany,

Thanks for your inputs.

Thanks RudiC.

I tried your solution but its failing for this case:
input:
this.something == 'something'.that
returns:
this.something == 'something'.that

...

Hi R. Singh,

Thanks for your reply.

Actually there could be more than one type of input statements. The provided one is just one of the type.

Let me add some more. Apologies from my part.

I am formatting my code and for that I am trying to write a script which can quicken some repetitive work.

I need to match "==" exactly in a string and replace it by inserting a (single) blank...

Thanks RudiC you have been a great help.

This version works exactly the way I wanted.

Well yes I read it but as I said the default file comes with | by default and it would be preferred if that wasn't replaced with something else as the files are very huge and it is not advised to...

So, I guess there's no solution for this then...

Nuhuh already tried, doesn't work

To clarify a little bit, 24 is the last line of my input file and source line is 1 because I ran your script by eliminating all the new lines and replacing them with semi colons.

When I run it the...

Thanks RudiC,

Your solution works great with tab as delimiter but I am using | and it is failing with the below error:


awk: 0602-521 There is a regular expression error.
*?+ not...

This is brilliant. Thanks @RudiC. This has reduced a lot of manual work.

@pravin27 I think for the current situation its ok for me to mention all the columns as either a key or an agg field as...

Yes that is exactly the question.

Can't we have a more generalised command that cover all the above scenarios?
i.e specify which column to aggregate with and which to comma separate.

Am I...

What I mean is, some tables are like:


B00000 1 ... abc
B00001 1 ... abc,def
B00001 2 ... ghi
B00001 2 ... jkl
B00002 1 ... abc
B00002 2 ... def
B00003 1 ... xyz


Can we edit the code...

Thanks @RudiC that worked great.

Sorry for the late reply. I didn't get time yesterday to check the code.

Can we make it more generalised like passing arguments such as in the example since I...

Hi,

Basically what I am trying to do is making multiple fields of the same type comma-separated.

i.e. for a data like this:

B00000 abc
B00001 abc,def
B00001 ghi
B00001 jkl
B00002 abc...

Didn't have that requirement but nice to know.
Thanks :)

@MadeinGermany using -e did the trick.

@Don it works

Thanks all.

Thanks @Aia that did exactly what I wanted.

Got to do some studying on perl. Can this be achieved using sed or awk?

@RudiC Will take care next time. Thanks for your inputs too.

I am getting something like this with your command

"The label :L; s/||/|-|/g;tL is greater than eight characters."

PLEASE use code tags as required by forum rules!

May be our seds are of...

Hey guys,

I have a file that is delimited by | and I am trying to write a sed command to
convert this:

abc|def||ghi|jkl||||mnop

into this:

abc|def|-|ghi|jkl|-|-|-|mnop


The output...