Search Results

OK, really thanks.

---------- Post updated at 03:19 PM ---------- Previous update was at 03:19 PM ----------



thanks a lot jim mcnamara

OK, thanks
In this case "file" is the name of my input file?
Where do i print the records what doesn´t have 58 characters??
Thanks

Hi,
I have a problem, please help me,
I have a flat file like this:

P00000000088888888999999999 0000999903 000000000000000000
P00000000077777777000000000 0000999903 000000000000000000...

hi all, i have a flat file delimited by pipe (|), and i'm loading it to sybase, the problem is when i do a select to the table of the database, the last field has new line ascii (\x0a):

38,'0\x0a ...

hi, i have a file with 5 lines, like this:

068|3|20080331|P|21090|5|0|0|0|0|0|0|0
068|3|20080331|P| |6|0|0|0|0|0|0|0
068|3|20080331|P|21040|7|0|233|105|161|6157|6656|101
068|3|20080331|P|...

#! /bin/ksh , that is the line at the top of the script

i have a problem with the instruction "echo >> my_file", when i do it manually, it works, but when i do it in a script, automatically, it doesn´t, deletes the last record, why??

ok, it works... thanks

hi all, i have this question: How to add new line character at the end of a file????

i need this because i am loading a file to sybase and i have problems with the last record
thanks for your help

hi,
i have a flat file, with lines (records), and fields, and each field is separated by pipe ( | ) :

1|078|012006|3,9
2|078|012006|8692275|4|2|GON3507090
2|078|012006|7655734|9|0|GON3507090...

is there a way using ksh to doing this?
because i don't know how to use perl... :confused:

thanks

hi all...
i need your help, because i don´t know what to do...
i have a flat file like this:

B065200512312004123111010000061451 000021853
B065200512312004123111020000621907 000417802...

hi all...
i have a big problem, and i hope someone can help me...
i have a flat file, and its columns are separated by comma (CSV), something like this:

78 , 204R180 , 90/100 , 200001 ,...

i run it and i have the next error message:

code:

cat f1.txt | awk -F ';' '{
for (i=3;i<NF;i++)
{
j=i+1
k=i+2
l=i+3
printf("%s;%s;%s;%s;%s;%s",$1,$2,$i,$j,$k,$l)
print ""
i=i+3
}
}' ...

Hi all...

i have a question, and i don`t know what to do ... i have a flat file what is separated by ";" and i need format it... here is an example:

this is what i have:

AAA ; BBB ; 1 ; 1.1...

to connect to sybase you can use isql from your unix script, or odbc if you are programming in c o perl.
the isql syntax is like this:

#!/bin/ksh
DOWN()
{
isql -b -U$user -P$password -S$server...

yes vgersh99, that is what i'm looking for.

if i had 5 files, i would have 7 fields in the resulting file:
2 fields with the unique keys
5 fields with values/empty for every 5 of the input files...

thanks a lot vgersh99

anyway, i still have a little question, if you can answer me i will thank a lot...
how can i do to keep white spaces, delimited by pipe (|), when there are not values in one...

thanks vgersh99, but if is not problem, i would like make you a question:

how can i do it to order the new file by the first 2 fields, when the 2 first fields have the same value, like this:
...

hi...
i have a big problem, and i don't know how to solve it.
here is the thing: i have 12 files, which are flat files, with several records(lines), and each record has 3 fields, wich are separated...

hi all,

i have a big problem, and i don´t know what to do.
i have a flat file with several fields, which are separated by ";" like this:

5656838-7B;97030000-7;*;V16106133 ;1;1;...

hi all,

i have the next question:
how can i identify the type of a file? . I'm working in Unix (Solaris 5.7) and i would like identify if a file is or not is a "flat file". I need have a program...

thanks vgersh99 - it works ok

hi all,

i have a big problem and i don't know what to do. This is the thing: i have a flat file with 26 fields, which are separated by ';'
by example, i have this:

Peter;Smith;2005;200508;...

hi all...
i have the next question:

i have a flat file with a lot of records (lines). Each record has 10 fields, which are separated by pipe (|). My problem is what sometimes, in the first...