Search Results

It is not working as if the output swapped between the first chunk of the carriage return with second chunk of the carriage return.

input sample:
a|b|c|d
e|e|f|g|h

Output:
e|e|f|g|h
a|b|c|d...

Thanks zaxxon for your reply, sad to say that it is not working...

the actual input file,

VALUE_ID|HPB_DIV_DEPT|KPI_ID|KPI_DESC|YEAR|VERSION|KPI_VALUE|KPI_VALUE_NUM|KPI_PERFORM|VALUE_STATUS|INACTIVE_DATE|UPDATED_DATE|UPDATED_BY|REMARKS|CREATED_DATE|MODIFIED_DATE...

Yea, zaxxon. I have tested with your code also.
It works with sample file, but not with my actual file.

Modified to be

/usr/xpg4/bin/awk -F\| 'NF<16 {l=l? l OFS $0: l $0; next} l {print l} 1...

Yes, rdcwayx, i have been posting the carriage-return-related topic as i yet resolve the issue :(

awk '{printf /^col1/||/^[0-9]/?RS $0:":::" $0}' infile

I executed the above code, running fine...

Hi all,

need your help in replacing carriage return in a record.

Input:

col1|col2|col3|col4|col5|col6|col7|col8|col9|col10
1|aa|bb|cc|dd|eee
eee|ff|ggggg|hh
hhh|iii...

Thanks a lot rdcwayx. It works.

I have one last question, when i print the output to file.txt the first line in file.txt is empty row. How to avoid that?

Sorry for missing out something in the Output.txt
I have compensated it as attached.

The code works fine, just that in column 23, if there is a carriage return, I need to replace it with 3 colon...

Thanks rdcwayx for your code.

When i tried the code, it hits error.

nawk: syntax error at source line 1
context is
{print >>> /^[0-9]+\|/||NR== <<<
nawk: illegal statement at...

i attached the input(Input.txt) and desired output (Output.txt) file as requested.

Requirement:
1. all carriage return existed in all columns except column 23 will replace with a space (the...

Hi all gurus,

Need your help in modifying the script written by tukuyomi and shipra_31
grep -v '^$' file.txt | nawk -F\| 'FNR==1{n=NF}NF<n{l=$0;getline;$0=l" "$0}1' > file_1.txt

This script is...

Thanks all for your response.

Mirni, sorry for the confusion. I uploaded the actual input file for your reference.

Correct_input.txt is the desired output.

However, sometimes the data may...

Thanks mirni for your reply, the script able to run now.

However, it doesnt work for my actual source file. The sample input file is merely example, i apologize for this.

Actual input file...

Thanks for your explanation.

I tested the script, and it doesnt work for awk command. Thus, i changed to nawk command.

It hits below error:

nawk: you can only delete array[element] at source...

Thanks all for your help.

I tried to run mirni's script, but it seems that i cant get through.
I suspected 'awk' command is not working, thus i changed to 'nawk'.

But i come to this error upon...

Thanks anchal_khare for your prompt reply.

In the example input, col3 is called multivalue column.
According to the requirement, user has not specified the fix number of value it might contain...

Thanks Chubler_XL for the code.

I haven't test out the script given. I am trying to understand the script before testing on the source file. I have included the comment on each if else statement,...

Hi All Gurus,

I need to replace a pipe <|> with a comma <,> in a few columns with pipe delimited file. The column name are fixed for the replacement of comma <,>.
For below example, Col3, Col6...

it doesn't work here.
It shows only the column header, the rest of data is chopped off.

output:
col1|col2|col3|col4|col5|col6|col7|Remarks|col9|col10

Thanks Shipra_31 for the script.

However, when in below situation - carriage return is occurred after "16", it is not working. In addition, it should not add <:::> How to tackle this? your help is...

Hi,

need your help in below,I have 4 types of file need to be processed so that it will replace carriage return in Remarks column with <:::>
Remarks column position may varies in different types...

thanks a lot tukuyomi, it works.

yes, it is always in the first line of the source text file.

Hi,

I have to process four source text files with possibility to contain carriage return on the particular column. Thus, i need to replace the carriage return with 3 colons <:::>

The particular...

Yazu, thanks.

In that case, how do i count the max number of column in the source file? Indeed, the source file comes with column header.