Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Load *, if(index(Code, ' '), subfield(Code, ' '), if(index(Code, '-'), subfield(Code, '-'), Code)) as Test
Hi,
index(Code, ' '), subfield(Code, ' ')
Index() returns position of space if it returns true i.e. position value more than 0
then perform Subfield ()
Subfield() gives data of Code before space
for example
if code = abc cde
then index(Code,' ') return 4
then Subfield(Code,' ') Operation Performs which return abc
if code = abc-cde
then second condition i.e. if(index(Code, '-'), subfield(Code, '-') perform
if code = abcde
then final else i.e. return all string
Regards
Hi,
index(Code, ' '), subfield(Code, ' ')
Index() returns position of space if it returns true i.e. position value more than 0
then perform Subfield ()
Subfield() gives data of Code before space
for example
if code = abc cde
then index(Code,' ') return 4
then Subfield(Code,' ') Operation Performs which return abc
if code = abc-cde
then second condition i.e. if(index(Code, '-'), subfield(Code, '-') perform
if code = abcde
then final else i.e. return all string
Regards
Hi expert,
as well as i have araised one more question expr2 please explain me that also