Search Results

Perfekt, that's it then!

Thanks again for your help :)

cheers
Mike

Ok thanks guys, I think I'm good now ... it works, except for the right numer iteration per line, but this is something I can figure out myself ...

cheers
Mike

---------- Post updated at 04:06...

create table:


CREATE TABLE MPR_TEXT
(
REF_CODE VARCHAR2(30 CHAR) NOT NULL,
TYPE VARCHAR2(30 CHAR) NOT NULL,
KEY1 VARCHAR2(30 CHAR) ...

not really ... only replaced your table name with my table name and changed fieldnames accordingly, nothing in the logic :confused:

That does the trick! But now the iteration for num is not working anymore, and shows just 1 for all lines?!

Ok, lets check in detail what I have ... my table text can be filled from different areas in an application ... there is a header dable and a detail table, and in the app a user is able to enter...

Very nice SQL! Looks good, except for the fakt, that it splits an entry in line 1 and line 2 and there is also a line 3 and 4 with the full line? Like


1 10 K1 K2 any text a user entered...

Hi,

I need a sql statement for a table, which simply stores a text. It has a column ID, key1, key2, ..., text, date etc. The text can be entered using a line break (return) in an oracle form.
...

Hi,

how can I use sub with blanks in my awk?

awk '{close(f);f=$1}{sub("^[A-Z][A-Z][A-Z]","");print > f".TXT"}' $_ftpfile

This removes the first 3 chars per line in my file $_ftpfile. I...

Hi all,

i have a .ksh script which is, among other stuff, splitting a file and saveing the filenames into variables for further processing:

# file split before ftp and put result filenames...

Works just fine, many thanks!

In this case yes, but as it should work with different files, which might then have other prefixes, it should more be a generic thing like to always cut off the first 3 chars per line. That would...

ok thanks so far ... forgot to mention that I have 4 files with 4 different prefixes per line :rolleyes:

so how about different prefixes, like BDD, BHD, BAD, BND?

Hi,

I'm using a .ksh script to split one file into multible files by checking for the prefix per line. It works perfekt (thanks again for anyone involved in helping me with that ;)), but I want...

I think it does not work that way within the same loop when creating the variables in the ksh?

do you maybe also know how to chmod the files? :D

perfekt, thnx!

Thanks!

Do you maybe also now how to manage, that the filenames are assigned to a variable in a loop, like:

set B*.txt
i=1
c=$#
x=$((c+1))
echo "$x"

while [[ $x -gt i ]] ; do...

Hi,

does anybody knows how to manage, that the filenames are assigned to a variable in a loop afer getting them with set command in a ksh, like:

set B*.txt
i=1
c=$#
x=$((c+1))
echo "$x"...

Hi,

I have a .ksh script, and I read files from a directory with "set" command:

set B*.txt

Means I can now assign with

file1=$1

the first filename found to a variable file1.
...

But this only creates the split files with the original filename of the file splitted in the new filenames?

The result is the files as shown in the directory:
...

Hi all,

I'm using awk in a .ksh script to split one file by line prefix into different files (up to 4). The files are named after the prefix in the line, and a sequence no.
Is there any way to...

Maybe some missunderstanding ... $_ftpfile is the file which is split into 2 or more files, and print > f".txt" is writing the filenames, right?

So I want this filenams in variables, so that...

The filename is different, cause I tried to awk manually on a file which was already transferred via ftp, which we mark with a suffix of the process id then.

Data is just dummy date, and files...

Sorry, but set -x does what?
The loop is in a .ksh script which is called from out an application with different parameters, and there is e.g. a file (variable $_dbgfile) which is used, to log the...