How to isolate a value in a column ? Enterprise\Toto\Sun

[bouderbc]

Hi experts !

How to isolate a value in a column ? Enterprise\Toto\Sun

Name of the Column : Enterprise

Text Format ( text with backslash) : .... \ ... \ ...

Enterprise\Toto\Sun

How to isolate Toto ?

Thanx

Regards

Ali

[Chanty4u]

try this

SubField(Enterprise,'\',2)         as toto,

[bouderbc]

Hi Chanty,

I have different text values like :

Enterprise\Toto\Sun

Enterprise\Alpha \Sun

Enterprise\Tango\Sun

So i don't want to replace the value , i want to isolate values in the middle , and have a column with Toto, Alpha and Tango

[tresesco · Accepted solution]

SubField() is the right function for it. Try like:

SubField( YourTextField, '\', 2) as NewField

Now, the field NewField would have your desired values.

[Chanty4u]

hi

did you tried this

you can give any name

SubField(Enterprise,'\',2)     as   YourFieldName,

[bouderbc]

Test OK .... Great !!! Thank You

[bouderbc]

Test OK .... Great !!! Thank You Chanty

[bouderbc]

Hi Treseco,

I need your help , i have a new text format like this : '27-09-2017' , and the problem that i try everything to change the format but with no success because of  the  quotes  '.... '  in the text format , i want to isolate

the date 27-09-2017 ?

[prieper]

REPLACE(MyDate, CHR(39), '')

/Peter

Am 27.09.2017 um 23:33 schrieb Ali Bouderbala <qcwebmaster@qlikview.com<mailto:qcwebmaster@qlikview.com>>: