Equivalent of Right() function

Question

Is there an equivalent of right() function that I can use in jquery. I want to get records with fileextension xlsx.

 new Guid(context.Documents.Where(T => T.FileName == ".xlsx").Select(T => T.ItemGuid).First().ToString());

something like

 select * from document where right(filename,4) = 'xlsx'

I don't want to store the filename in a variable and later manipulate it. I want to be able to directly use it in my where condition. 'Documents' is my table name and "FileName" is a field that holds names of the file that I upload, now I need to get filter only the files that has the extension 'xlsx'. I tried doing

  guid temp = new Guid(context.Documents.Where(T => T.FileName.Substring(T.FileName.Length - 4) == ".xlsm").Select(T => T.ItemGuid).First().ToString());

but I get the error "Sequence contains no elements" error.

* Update: Used the EndsWith() to get the information I wanted. This works now:

  guid temp = new Guid(context.Documents.Where(T => T.FileName.EndsWith("xlsm")).Select(T => T.ItemGuid).First().ToString());

thanks.

*select * from* looks more like sql than jquery, i wish i knew who upvotes this — Michal Klouda, Sep 10 '12 at 16:44
What exactly is `document` or `filename` in relation to the DOM? — SliverNinja - MSFT, Sep 10 '12 at 16:48
@lonesomeday was trying to see if I could use like a right() funtion in the jquery statement I had above. — sansid, Sep 10 '12 at 17:29
@MichalKlouda the select * statement was just as an example on what I wanted, got nothing to do with jquery — sansid, Sep 10 '12 at 17:30
@silverninja document is my tablename and "filename" is my field — sansid, Sep 10 '12 at 17:31

raina77ow · Answer 1 · 2012-09-10T16:53:12.400

1

You can use .slice (MDN) function, taking into account that passing a negative value into it makes it cut the string from the end. )

var test = 'filename.xslx';
if (test.slice(-4) === 'xslx') {
  alert("Passed");
}

edited Sep 10 '12 at 16:53

answered Sep 10 '12 at 16:45

raina77ow

103,633
15
192
229

1

`.substring` does not take negative indices. – jackwanders Sep 10 '12 at 16:47
@jackwanders Fixed. In fact, somehow I thought `.slice` behaves like that. – raina77ow Sep 10 '12 at 16:56

score 1 · Answer 2 · answered Sep 10 '12 at 16:46

1

filename.substr(-4)

Using .substr with a negative index will return a substring from the end of the string.

answered Sep 10 '12 at 16:46

jackwanders

15,612
3
40
40

Erm... isn't `substr(negative)` not supported in IE8? ) – raina77ow Sep 10 '12 at 17:00

score 0 · Answer 3 · answered Sep 10 '12 at 16:46

0

You might be looking for [name$="value"] selector documented here.

answered Sep 10 '12 at 16:46

Michal Klouda

14,263
7
53
77

score 0 · Answer 4 · answered Sep 10 '12 at 16:46

0

There is not, you can use

var filename = "file.xlsx";
var extension = filename.substr(filename.length - 4);

or to get the characters after the dot, you could use:

var extension = filename.split('.').pop();

answered Sep 10 '12 at 16:46

Rusty Jeans

1,426
9
10

score 0 · Accepted Answer · edited May 23 '17 at 10:34

0

right() is the same as endswith()

function endsWith(str, suffix) {
    return str.indexOf(suffix, str.length - suffix.length) !== -1;
}

edited May 23 '17 at 10:34

Community

1
1

answered Sep 10 '12 at 16:46

SliverNinja - MSFT

31,051
11
110
173

score 0 · Answer 6 · answered Sep 10 '12 at 16:47

0

Use could javascript match() which provides regex matching.

var filename = 'somefile.xlsx';
var matches = filename.match('/\.xlsx$/i');
if (matches.length > 0) {
    // you have a match
}

answered Sep 10 '12 at 16:47

Mike Brant

70,514
10
99
103

Equivalent of Right() function

6 Answers6