Search Results

Hi,

Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge,...

Field Genre can have any number of values separated by a newline delimeter.

Hi,

I have a requirement that has 50-60 million records that we need to split a delimited string (Delimeter is newline) into rows.

Source Data

SerialID UnidID GENRE
100 A11 AAAchar(10)BBB...

Hi,

I have a requirement that has 50-60 million records that we need to split a delimited string (Delimeter is newline) into rows.

Source Date:

SerialID UnidID GENRE
100 A11 AAAchar(10)BBB...

head -1 $filename|cut -c102-128

I was able to get it done..thanks..

hi,

I want to store from 102 character to 128 character to a variable of header record which can be identified as 'HDR' which is the first 3 characters in the same line of a same.txt file.
Please...

hi,

I would like to search for a specific string at a specific line in a file and would like to know the count of it.

eg: samp.txt

ABC 1234 BELL
HNZ 4567 RING
NNN 5673 BELL


Please...

gr8..thanks/...it worked..)

Hi anbu23,

Thanks for quick reply..so this will check for the string only in the 6, 7, 8, 9 positions only right..and it should not check any other positions of every records of the file..

sed...

Hi,

I have following samp.txt file in unix.

samp.txt

01Roy2D3M000000
02Rad2D3M222222
.
.
.
.
10Mik0A2M343443

Desired Output

01Roy2A3M000000
02Rad2A3M222222
.
.

Gr8..thanks..this is working..)

hi,

Does anyone has any idea in adding few blank spaces at the end of every record in a file.

Eg:

file.txt

Baby Boy Kim 1234
Baby Boy Vik 1334

Desired output:-

output.txt

Baby...

Hi,

I have a test.txt and would like to put in a different file but while putting in the other file, blank spaces are missing.

$ indicates blank spaces

filename: test.txt:

USA$$$840$$$$
...

$ indicates blank space

file1.txt:
001_AHaris$$$$$020$$$$$$$$$
001_ATony$$$$$$030$$$$$$$$$
002_AChris$$$$$090$$$$$$$$$
002_ASmit$$$$$$060$$$$$$$$$
003_AJhon$$$$$$001$$$$$$$$$

$ indicates...

CODE: awk '{ str=substr($0,0,5); print >str; }' file.txt

Please find the following error..

awk: A print or getline function must have a file name

The input line number is 6. The file is...

while read line;do echo "${line#*_}" >> ${line}.txt;done < file.txt

still not getting the blank spaces...after the end of the line in the file..

I have a file which has blank spaces($) and the blank spaces at the end of the file are not coming up while cutting the files.. please find the following file, desired output..

file1:...

Thanks this is working...

Hi,

I have a fixed length text file that needs to be cut into individual files in aix and facing padding issues. If I have multiple blank spaces in the file it is just making it one while cutting...

tHANKS

Hi,

I have a file which have set of rows and has to create separate files based on the id.

Eg:
001_AHaris020
001_ATony030
002_AChris090
002_ASmit060
003_AJhon001
...

Hi,

I have a file which have set of rows and has to create separate files based on the id.

Eg:
001_AHaris020
001_ATony030
002_AChris090
002_ASmit060
003_AJhon001
...

I would like to replace the value of * (which might have one or more whitespace(s) before and after *) using sed command in aix.

Eg: Var='Hi I am there *

Desired output: Hi I am there*

While doing cat on a large file (3 GB file) , I am getting the no space error in the shell script hugefile.sh.

Eg: for i in `cat hugefile.txt`
do
echo "$i"
done

error:...