Regarding right and left fun exp?

[d_koti24]

Hi All,

I have some paths are there in field,

like

path:

abcdjhjhjfgjf\snsbnsb\ajkdjjhjhf\

jhsdhfjdhfjh\dd\sdd\dfdfd\

jhjdhfjdh\f\sd\

dfd\hg\rtrtr\ee\e

My Req is i want retrive upto to second '\' only in all the data.hw to achive this?

ex:

abcdjhjhjfgjf\snsbnsb

jhsdhfjdhfjh\dd

jhjdhfjdh\f

dfd\hg

regards,

kd

[Colin-Albert · Accepted solution]

Have a look at the Subfield() function.

     subfield(your_data, '\', 1) & '\' & subfield(your_data, '\', 2)

[MK_QSL]

SubField(FieldName,'\',1) & '\' & SubField(FieldName,'\',2) as NewFieldName

[Ralf-Narfeldt]

SubField(path, '\', 1) & '\' & SubField(path, '\', 2)

[sunny_talwar]

This should also work for you:

=Left('abcdjhjhjfgjf\snsbnsb\ajkdjjhjhf\', (Index('abcdjhjhjfgjf\snsbnsb\ajkdjjhjhf\', '\', 2)-1))

Replace abcdjhjhjfgjf\snsbnsb\ajkdjjhjhf\ with your field name

HTH

Best,

Sunny

[sunny_talwar]

In the script, you can use this:

Table:

LOAD Path,

  Left(Path, (Index(Path, '\', 2)-1)) as NewPath

Inline [

Path

abcdjhjhjfgjf\snsbnsb\ajkdjjhjhf\

jhsdhfjdhfjh\dd\sdd\dfdfd\

jhjdhfjdh\f\sd\

dfd\hg\rtrtr\ee\e

]

Output:

[d_koti24]

Thanks to all,

all are expressions working perfectly.