Search Results

You have 2 options.
Option 1: Open the file then go to menu DATA --> Text to Column. Follow simple instructions and will see the data in your format.

Option 2: Replace the comma's with Tab...

Thanks zaxxon.

A slight change,

My file is of below format:

abc,111,222,333,jjj,22
xyz,398,399,834,ww,33
jdj,398,947,487,eee,44
abc,535,33,34,jjj,22
sss,43,3,53,dd,ter,33...

Hi all,

My file is of below format:

abc,111,222,333
xyz,398,399,834
jdj,398,947,487
nmn,535,33,34
sss,43,3,53
ks,343,3,4
d,94,94999


I want to insert 2 rows(NULL,0,0,0) after every 3...

Thanks. this works fine for me.

I have text file, i want to replace all the charecters with tab.
suppose:
cat abc.txt
dfjkdf
dfdfd
fd
fd

the output should have 4 lines and each line will have 1 tab.

Thanks
:confused:

hi All,

I have one file:
gain an overview. sue the swquesces. capture
333.captured
tesh the values in the history.
There may be something. caputure
111.done
Then there is
nothing everything...

Can anyone throw some light on this too.
Thanks in advance.

Thanks
Javeed

Hi Shiva,
Please let me know, how you are loading the fine in TERADATA. Using fast load or multiload or ?

As per your question, i think u can find and replace two pipe lines as |NULL|.
For this...

Could anyone update on this.
Very less options are available for me to work on this.

Thanks

HI All,

Neeed help on grep lines from the file.

I have one file abc.txt. In that "capture above two lines" will be present. I want to capture only those above 2 lines in other file.
for Eg:
...

Hi devtakh,

Thanks for your quick reply.
But, the number of columns may differ from file to file.
I mean to say that the number of columns are not constant.
Could anyone please suggest any...

Hi All,
I have a comma seperated file.
I wanna remove the spaces from column 2. I mean i don't wanna remove the spaces those are presnt in column 1.

ex:
emp name, emp no, salary
abc k, abc...

It worked.
Thanks a lot radoulov.

Hi all,

could anyone tell me, how to convert the .csv output to an xml file.
The csv file is as follows:

EmployeeName,Empno,Salary
aaa,111,1000
bbb,222,2000
ccc,333,3000

Any help is...

HI All,

I am running one shell script, in that script i am calling 4 scripts in the background.

abc.ksh &
efg.ksh &
xky.ksh &
mno.ksh &

please let me know, how could i find the success...

Thanks Franklin52. It worked for me.

let me explain my problem with example

abc.ksh
=======
echo 'Hi' > ab_log.log
echo 'i will run some commands' >>ab_log.log
echo 'Will do some manipuations >> ab_log.log
echo 'end'...

Hi All,

i have a file in which i wanna a grep the word which contains .txt
suppose in a script i user abc.txt for 10 times.when i use grep or other command it has to give me one line output ie.,...

If anyone didn't understand anything, please let me know.

Thanks

Hi All,

I have a peculiar problem. I will call a script from another script.
Script abc.ksh is called by ABC.ksh as

ABC.ksh abc.ksh

in abc.ksh I will create and redirect all the statements...

HI,

Can anyone has automated sftp script?
I want to upload one file from one server to other.
Could anyone help us?

if anyone didn't understand, please let me know.
could anyone give reply to my question.

Hi,
Could anyone please tell me, how to send html file with attachment.
My file size is nearly 7MB.
When I send mail through sendmail, I can see see the html format output but not able to see the...

Hi,
djfksdjk)))) kmmm jfdfjk))))
I want to replace the first ')' after kmmm with #.
The output would be djfksdjk)))) exists jfdfjk#)))

Can anyone help on this?

hi all,

Can i have case in sensitive find and replace in sed.
sed 's/ilovemycountry/loves/g' file.txt.
Any special flag to make my find(ilovemycountry) as case insensitive.
Please suggest.