EULANDA® ERP System Head Start thru Technology

cnf_ExtractVal

Back | Level back

This function scans a note field for a certain text and returns the delivery as result the remainder of the line as text. This function is particularly well suitable, in order to indicated in the browser or in pressure lists of pseudo fields. Since the search text can be arbitrary, it is to be spent possible as many as desired pseudo fields to scanning.

Become in the record sheet e.g. at the start of line.

01#  That is the first line
02#  That is the second line

entered then the function, if for '01#' one searches, can return the delivery the line remainder, thus 'that is a line'.

Syntax

cnf_ExtractVal @Langtext, @St

Argument

@Langtext memo
@St varchar

In this example the note field with the name "record sheet“ is scanned for a lozenge. If it is found then the remainder of the line is spent. The name "SN“ behind the function call is that field alias.

Example

SELECT Match, dbo.cnf_ExtractVal (record sheet,'#') SN FROM Address


Output:

Match              SN 
-----------------  ---------------------
PURETEC            859-96C-632
DATA SOLUTION      636-9CE-423

(2 Lines) effected)

Commands finally successfully

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.