Search Results

turns out perl environment had changed so was referring to a library location that didnt exist

ill try that but just to note the reformatnwc.sh is working
when i execute it by itself
its when i try and run it from the perl command that it fails

see scripts attached
i was just trying to test fadditional lines in the perl script
reformat .sh reformats the file customerdata.txt
all files are in the same folder and have executable...

tried running it straigth from the prompt without the fullstop
awk: syntax error near line 5
awk: illegal statement near line 5
with the fullstop
ksh: syntax error: `(' unexpected

ksh: syntax error: `(' unexpected


all i had in the script is

!/usr/bin/env perl
#
system("reformatnwc.sh CustomerData.txt tt.txt");


tried running it from the propmt using ....

got confused with login names

yes i am


this is what i tried

the script takes two variables 1 input 2 output name

!/usr/bin/env perl

system("reformatnwc.sh CustomerData.txt...

well thank you all

Thanks danmero (https://www.unix.com/members/302032802.html)
that works perfectly

Thanks franlyn
tried code but it still doesnt facilitate if field 1 or field two is empty
dont create record in that scenario .
Look at file attached
record 1 should only create one record...

see files attached file before is before conversion file after is what is expected after n:B if field obene of field two is empty then record must not be created
field one or field two must exist...

unix script must do the fiollowing

open a file containing comma delimited records
> each record contains 10 fields
> removes the 2nd field and use that same field containing fields 2 to 10...