Search Results

Hi Klashxx and DILEEP410,

The command is running ok now and I able to get the result that I want.

Thank you so much for your help. Really appreciate it. :)

Thank you.

Best Regards,...

Hi Klashxx,

Yup, is Solaris box.

Hi DILEEP410,

The command is ok but it didnt return the path that I want, the LANGUAGE, DIALECT and FILE value are missing. Please advise.

RESULT:...

Hi Klashxx,

I get the below error when execute the command:

awk: syntax error near line 1
awk: bailing out near line 1

Try to solved it many times already but still getting the same error....

Hi all,

Hope all the expert can help me in this situation.

Let say I have one file with multiple record like below:

[10001]
NAME=FRAGMENT
LANGUAGE=1
DIALECT=0
GENDER=NONE
FILE=TEST1...

Hi all,

Is there any command that can be used to convert the date from String to Date datatype by using shell script?

Let say I have the date like 01/01/07 from an input file, before I able to...

Hi all,

Let says I have date in string format like 01/01/08, how can I insert it into MYSQL table as DATE data type?

I created the table and declare data type for Date column as DATE, when I...

Hi sysgate,

Sorry that I just have time tested on this.

After I load the data from text file, all the value become NULL in the database. I created the datatype to be VARCHAR(32) and also...

Hi vgersh99 and ranjithpr,

The script is working now and I able to get the output data that I needed.
Thank you so so so much for your helps. :)

Thank you.

Best Regards,
Shirley

Hi vgersh99,

I have tested on the script with test data, but no output is showing. The output file is empty. Tried to modify the script, but still the same. :(
Please advise.

Thank you so...

Hi,

I have a question here that need to get advise from all of you. Let say I have a set of data

12347777
12359899
12347677
12360090
12347688
12359979
12359009
12367022
12346677

I...

Hi,

Need to get help from you guys about this issue.

I need to insert data into MySql database from a text file which is located in other server.

The text file is something look like below:...