Login or Register to Ask a Question and Join Our Community


Programming

Code problem

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming Code problem
# 1  
Old 03-02-2011
Code problem
Hey just wondering if someone can tell me the right line of code to use.

Basically my product codes for an ecommerce site all begin with three letters and an '/' sign

e.g ABC/1234 would map to the brand ABC in my excell file(product upload mapping)

This was done as the csv generating from my POS database wasnt generating brand names.

See line in code it basically says that after the first three letters that are separated with the '/' symbol they will map the brand name right.

Now we have changed 2 products to contain a '-' symbol instead of '/'

ABC-1234 instead of ABC/1234.

I need the right sql code to say anything with a - is added just like the / sign.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with a code.

Guys i have one file and i want the o/p from that file like below This is my sample file and i want below things from it. Name: Sate just below the name: And retention Level Name: MEANS_SLP_DAILY State: inactive Retention Level: 3... (6 Replies)
Discussion started by: nirjhar17
6 Replies

2. Shell Programming and Scripting

Problem with a code.

Guys i have one file and i want the o/p from that file like below This is my sample file and i want three things from it. Name: State just below the Name: dont want the state under the Retention Level: And retention Level Name: MEANS_SLP_DAILY State:... (1 Reply)
Discussion started by: nirjhar17
1 Replies

3. Shell Programming and Scripting

Unknown (probably) simple problem with my code

I'm relatively new to both UNIX and Linux and slightly less new at programming. But I can't figure out why this won't run properly. It's meant to calculate the GCD of two numbers (simple enough, you'd think). And I designed it myself and it looks good to me and my instructor won't respond. If... (1 Reply)
Discussion started by: Sevchenko
1 Replies

4. Shell Programming and Scripting

Escape code problem again

Now theres another problem. I would like to output not just a colored block, but how would I output not a solid block character, but a shaded block instead? Please help. I'm writing a library for these codes and this would really help. (4 Replies)
Discussion started by: tinman47
4 Replies

5. Shell Programming and Scripting

Perl code Out of memory problem

Hi I am working with a 3.0 GB file and running the following script to process it. After running for 15 minutes, the script stops saying Out of memory or Killed. Can the experts suggest where my code can be improved to save memory? Thanks in advance. #! usr/bin/perl use warnings; open... (3 Replies)
Discussion started by: polsum
3 Replies

6. Windows & DOS: Issues & Discussions

Problem compiling C++ Code in Cygwin

Hello everyone. I just recently installed Cygwin and I am running it under Windows 7. My problem is that I cannot seem to compile any C++ code with g++. I've tried to compile C Code using gcc and that works just fine. But Whenever I try to compile some C++ code, g++ throws a whole bunch of... (6 Replies)
Discussion started by: Anlex
6 Replies

7. Shell Programming and Scripting

Ftp code problem

Hello I am trying to write a script that sends files via ftp from one server to another, i am using AIX 5.1. and bash shell to write my code. I get an error when trying to run the following lines of code ftp -n aptsbou01 <<! user $username $password binary ... (4 Replies)
Discussion started by: kswaraj
4 Replies

8. Programming

problem with this code

This code is not working properly because it dont open the requested file. I am not able to find out what the error is?? can anyone fix the error for me?? #include <sys/types.h> #include <sys/wait.h> #include <stdlib.h> #include <stdio.h> #include <string.h> #include <unistd.h> #include... (2 Replies)
Discussion started by: badshah
2 Replies
Login or Register to Ask a Question

LEARN ABOUT MOJAVE

csreq

CSREQ(1)						    BSD General Commands Manual 						  CSREQ(1)

NAME

     csreq -- Expert tool for manipulating Code Signing Requirement data

SYNOPSIS

     csreq [-v] -r requirement-input -t
     csreq [-v] -r requirement-input -b outputfile

DESCRIPTION

     The csreq command manipulates Code Signing Requirement data.  It reads one requirement from a file or command arguments, converts it into
     internal form, checks it, and then optionally outputs it in a different form.

     The options are as follows:

     -b path
	     Requests that the requirement read be written in binary form to the path given.

     -r requirement-input
	     Specifies the input requirement. See "specifying requirements" below. This is exactly the same format as is accepted by the -r and -R
	     options of the codesign(1) command.

     -t      Requests that the requirement read be written as text to standard output.

     -v      Increases the verbosity of output. Multiple instances of -v produce increasing levels of commentary output.

     In the first synopsis form, csreq reads a Code Requirement and writes it to standard output as canonical source text.  Note that with text
     input, this actually compiles the requirement into internal form and then converts it back to text, giving you the system's view of the
     requirement code.

     In the second synopsis form, csreq reads a Code Requirement and writes its binary representation to a file. This is the same form produced by
     the SecRequirementCopyData API, and is readily acceptable as input to Code Signing verification APIs. It can also be used as input to subse-
     quent invocations of csreq by passing the filename to the -r option.

SPECIFYING REQUIREMENTS

     The requirement argument (-r) can be given in various forms. A plain text argument is taken to be a path to a file containing the require-
     ment. This program will accept both binary files containing properly compiled requirements code, and source files that are automatically com-
     piled for use.  An argument of "-" requests that the requirement(s) are read from standard input.	Again, standard input can contain either
     binary form or text.  Finally, an argument that begins with an equal sign "=" is taken as a literal requirements source text, and is compiled
     accordingly for use.

EXAMPLES

     To compile an explicit requirement program and write its binary form to file "output":
	   csreq -r="identifier com.foo.test" -b output.csreq

     To display the requirement program embedded at offset 1234 of file "foo":
	   tail -b 1234 foo | csreq -r- -t

FILES

DIAGNOSTICS

     The csreq program exits 0 on success or 1 on failure. Errors in arguments yield exit code 2.

SEE ALSO

     codesign(1)

HISTORY

     The csreq command first appeared in Mac OS 10.5.0 .

BSD
								   June 1, 2006 							       BSD