Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by trumb1mj
-
Using the 'system()' function??
Yeah, it was an escape issue. I solved the problem yesterday. Man can Perl be ugly at times! Thanks for the help! -
Using the 'system()' function??
Sorry about all the posts to my own post but this will be helpful. The problem definitely is consecutive '\'. But thats the only way I could get this command to work from the command line. Please someone, is there an alternative for consecutive '\' in perl. Please help. Thanks! -
Using the 'system()' function??
Is system() used to send text to the command line? -
Using the 'system()' function??
The problem is, the '\' are causing the perl script to think that an action should occur while I want to send what ever is in the () to the command line exactly how it appears. -
Using the 'system()' function??
Hi everyone. First I will try and tell everyone what I am trying to do. I am trying to send an 'isql' command to the command line using perl. Would I want to use the system function for this? Here is my current code: system (isql -S uschi00tst88 -U sa -P -d CTCMaster -Q "DELETE FROM... -
SQL and Perl Scripts
Ok. I have a problem completing a data fill prjoect. First of all, here is my scenario. I have created a perl script to create data files. These data files are then loaded into the database using Bulk Insert in the Query Analyser. As it stands, this is a multi step process. I was wondering...- trumb1mj
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Parsing Data Using Split
I would want: 1,100,200,2,400,3,800,4,1600,5,alpha,6,beta; 2,100,200,2,400,3,800,4,1600,5,alpha,6,beta; 3,100,200,2,400,3,800,4,1600,5,alpha,6,beta; 4,100,200,2,400,3,800,4,1600,5,alpha,6,beta; 5,100,200,2,400,3,800,4,1600,5,alpha,6,beta; and so on. so the input is used to create several outputs. -
Parsing Data Using Split
this is the area of focus, but I did not get the correct output.... it only changed the format and did not add 1 to the first column. any other ideas? thank you so much for trying. -
Parsing Data Using Split
I'm sorry about the confusion, I am very new to Perl. Maybe it would help by discussing the problem. I am a QA analyst and I am trying to test some software. I am trying to easily create test data for an SQL db, by using a template(input.txt) file. I want my Perl script to be runnable from... -
Parsing Data Using Split
Well that would work, the only problem is, I have taken my headings out of the input.txt file. I have made some changes since the last update. Here there are: #!/usr/bin/perl open(FILE,"input.txt") or die("Unable to open file"); @inputFileData=<FILE>; close(FILE); $line=@inputFileData[0]... -
Parsing Data Using Split
the input will be a single line: ID=10; Strike=233; and the ouput will be several lines from that single line (only changing the the ID): 10,233 11,233 12,233 -
Parsing Data Using Split
Task Overview: I am writing a Perl script to look through 'input.txt' and put this data into 'output.txt". The input.txt file looks like this: ID=10; Strike=233; etc... I want my output.txt file to look like this (or similar): 10,233, etc... I have my out put looking like this, the only...
