Search Results

Hi,

I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? :mad:

echo " Column filename format...

all, it work now.

I am just tried to use my original script and based on your comment,

echo Input file list to check:
read filelist
for file in `cat $filelist.txt`
do
echo "select FILENAME from FILE_TABLE...

I am tried to use your suggested while, is not work :eek:

sorry about the typing mistake, the % should be removed, like this

echo "select FILENAME from FILE_TABLE where filename like '${file}';"

Also, I used backticks in unix, still not work :-(

Hello,

I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused:

echo Input file list to check:
read filelist
for file...

Hi User,

I have a text file with a lot of customer records (over 10,000). Each record contained one field called "charge" and it must start with some space (each record may have 15 space, 17...

Thx, but the output is empty...
:mad::mad:

Hi,

I don't know how to grep two value with "" in the file, anyone can help?

for example:
the text file
John cash "1234" "ok"
may card "1245" "unknown"
John card "4567" "ok"
may cash...

Hello,

I have the following report (report.txt) file (see attached).

I would like to check the file and if the field is error, then showing error message at output.

1. In the report, 1st,...

Thx all. It work!!!!! :b:

Hello Guy,

I have the following information in the sample.txt, can i get the number and output into sample2.txt


-[000039:000008135]
-[000040:000008329]
-[000042:000008723] ...

Hello,

I have the following script to restore file and grep information. However, once it restore file, it showing a lot useless information and different to check which file have the statement...

thx..but how can I check my OS in unix?

Hello,

I have over 200 files and some of them have the string like "John price $200". I would like to grep the string. Then output the filename which found the string.

I have the following...

anyone can help????

Hello,
I have the following basic script which is remove the fielld. How can I replace another value in the field? Thx!!

for file in `cat $listn.txt`
do
get_file -q $file
grep -v...

anyone can help????

I will input the list filename.
For example: the filename is "customer.txt" and it contains the following:

Tom
John
Marry
Peter

It's still not work.:mad:
nothing in the output.txt
If I just copy the startment below, it work ok.

echo "select cuname as \"FROM CUNAME\", invo_num as \"RECS\", total_amount as \"AMOUNT\",...

Hello,
I have a script to run a list of customer information, but it not work. can anyone help below:

echo "Please input list to check customer detail:"
read list
for file in 'cat $list.txt'...

thank you very much for your help.

I have some idea for this.....:):)

can i ask you one more question.
if the filed 6 should incorrect time format like "hh:mm:ss:00", can I write a simple...

anyone can help for this?

can you provide an example for me?

thx!

hello,

I have a record below and would like to change the time fromat from m:ss to mm:ss

input
00001,CUSTR,CUSTOMER,02310,N,0:00,0,0,0,0,0,0,0,0,0,0,0,0:00,0,0,0,0,0,CSH,...