Search Results

Search: Posts Made By: chumsky
9,081
Posted By chumsky
jayan, you are a star :) Thank you
jayan, you are a star :) Thank you
9,081
Posted By chumsky
Replace colon with blank space
Dear Gurus,

I have a unix file with multiple colons on each row, and I would like to replace each colon with a blank space using the awk command.

For example, I have the following data:
...
13,024
Posted By chumsky
Brilliant. Thanks!!!
Brilliant. Thanks!!!
13,024
Posted By chumsky
Duplicate column in unix file
Hello,
I have a fixed width unix file with 2 columns containing the following data

ZTXX_CTBR1-ZBRAN1 ZTXX_CTBR1-ZBRAN_DESC
01 CASH &...
9,356
Posted By chumsky
Thanks, I did not manage to get it to work....
Thanks, I did not manage to get it to work. Trying another approach, what if the file is a fixed with file with 40 characters per column, and I want to copy from 41-80, into 81-120

For example,...
9,356
Posted By chumsky
Here is the result I am getting: 01#CASH &...
Here is the result I am getting:
01#CASH & CARRY##
02#DRUGSTORE - RX##
04#SUPERMARKET##
05#HYPERMARKET##
17#DRUGSTORE - NO RX##

What I need is exactly what you posted:
01#CASH & CARRY#CASH &...
9,356
Posted By chumsky
Already tried that, same result
Already tried that, same result
9,356
Posted By chumsky
Hello, os version HP-UX awk - B.11.31 ...
Hello,

os version HP-UX
awk - B.11.31

We don't have nawk installed
9,356
Posted By chumsky
Hi vgersh99, Thanks for the reply....
Hi vgersh99,
Thanks for the reply. unfortunately the third column is still blank after executing the script. Any other ideas?

Thanks,

Chukwuma

---------- Post updated at 08:33 AM ----------...
9,356
Posted By chumsky
Thank you for your reply. The first part worked...
Thank you for your reply. The first part worked with the removal of the header, however the second column was not copied copied. Here is the output I got:

01#CASH & CARRY##
02#DRUGSTORE - RX##...
9,356
Posted By chumsky
Copy column to another column in unix
Dear Gurus,

I have a unix file 2 columns (# delimited) with the following data:

ZTXX_CTBR1-ZBRAN1#ZTXX_CTBR1-ZBRAN_DESC#
01#CASH & CARRY#
02#DRUGSTORE - RX#
04#SUPERMARKET#
05#HYPERMARKET#...
8,236
Posted By chumsky
Add leading zeros to columns in a file
Hello Gurus,

Quick question. I have a file with the following records:

A~000000000000518000~SLP ~99991231~20090701~88.50~USD~CS~
A~000000000000518000~SLP ~99991231~20090701~102.00~USD~CS~...
2,261
Posted By chumsky
Manipulate and move columns in a file
Hello Unix Gurus,

I have a request 2 perform several functions on a file, delete columns, delete rows based on column value, and finally move around columns in the final output. Consider the...
6,684
Posted By chumsky
I am not sure I understand where the \t needs to...
I am not sure I understand where the \t needs to be placed in the command. Assuming the file name is current.txt, how do I need to update the code:
$ nawk -F"\#" '{ if(NR>1)...
6,684
Posted By chumsky
convert # delimited text file to fixed width
Hello gurus,
I have a file containing 5 columns delimited by '#' as shown in the example below:
HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA#
99991231#AU7129#000000000#1...
3,644
Posted By chumsky
yes, something like this, but columns 7, 8 & 9...
yes, something like this, but columns 7, 8 & 9 are misaligned
3,644
Posted By chumsky
sorry I meant to say that it is # delimited, and...
sorry I meant to say that it is # delimited, and not tab
3,644
Posted By chumsky
Delete header row and reformat from tab delimited to fixed width
Hello gurus,

I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned....
5,727
Posted By chumsky
you are a star! Thank you
you are a star! Thank you
5,727
Posted By chumsky
Thank you very much itkamaraj. This works...
Thank you very much itkamaraj. This works perfectly, only thing I am missing is how to start reading the file from row 4. Any ideas?

Thanks!
5,727
Posted By chumsky
Delete a row from a file if one column containing a date is greater than the current system date
Hello gurus,

I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4:...
Showing results 1 to 21 of 21

 
All times are GMT -4. The time now is 02:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy