Search Results

These rows are random. I used sed command to convert the intial delmiters to another value and then tried to strip the additinal chars from the required column


echo "1,A,USA,0" > test_input.dat...

Here is a sample. I am using ',' as field delimiter instead of cntl-a.1,A,USA,0
2,B,GERMANY,0
3,C,IND,IA,0
4,D,CH,INA,0

In the above example, the values "IND,IA" and "CH,INA" are coming from...

Hi All,

I currently have flat file with 32 columns. The field delimiter is cntl-A ( \x01). The file has been extracted from an oracle table using a datastage job. However, in the 6th field, the...

I tried these steps:


Used the below command to roll all the lines into a single line
sed -i -e :a -e 'N;s/\n//;ta' input_file.txt

2. Then converted the ~ to a new line


sed -i...

I have a text file with contents like this:
a,b,c,
d~e,f,g,h~i,j
,k,l,m~n,o,p,q~

I need to convert this file into this format unix shell script commands:
a,b,c,d~
e,f,g,h~
i,j,k,l,m~...