Search Results

Hi All,
I have a file with 20 columns, and the data itself has "\n" new line in it. So we have changed the row delimiter to ^E.

Now i am unable to use head, wc -l etc... Please let me know how...

I will try to post some of the data, watever i have it has some PII so this is the information i have as of now

• 'Binary' = 2-byte integer, n, followed by n bytes of data. In this format:
• The...

okey
when i run file filename it gives data

Actullay converting to ASCII is enough - After converting i need to scp that file to another server and it will be consumed by some other downstream...

Hi Scoot,
THanks for the reply, As i told its a file extracted from a database table with '~' as a delimitter; The file might contain arbitrary No. of columns each time. Strings is not converting...

Hi All,
I have a binary file which is being exported from a Database, and i need to convert that to ASCII format. How can i achieve that? And this solution should work for any file which is...

Thanks pravin27 :-) Works like a charm :)

---------- Post updated at 02:03 AM ---------- Previous update was at 02:02 AM ----------

pravin27,
Is there anyway we can do it without using PERL?

Hi jotne,
The find and replace should start only when we encounter "DATE", as a whole. so the string before it doesnt matter, ony the string from "DATE" and after that till the end of line is...

Hi All,

I have data like below
1 CREATE TABLE temp123
2 (
3 col1 INTEGER,
4 col2 CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
5 col3 DECIMAL(19,0),
6 col4 VARCHAR(80) CHARACTER SET LATIN...

I noticed that and changed, But u were too fast :)

Hi All,
I have a an array, in which i need to loop through all the variable and check each variable individually for a pattern.

For ex
#!/bin/ksh

set -A FileNames $(</Temp/AllNames)
echo...

Hi corona, U r code is throwing bad substitution error.
"${DATE:6:2}": bad substitution

Hi elixir... can u pls explain the solution?

---------- Post updated at 11:14 AM ---------- Previous update was at 11:10 AM ----------

Hi spacebar... Theres s no -d option available in AIX...

I have a date in format YYYYMMDD, i need to get the day of the week from the given date. I am working in AIX system.

---------- Post updated at 09:59 AM ---------- Previous update was at 09:57 AM...